SQL1


              

SQL1


SQL
ANSI

PL/I



SQL

DATE TIME


FORMAT





INTERSECT MINUS




" "?


( )


:

SQL

2. SQL. .
SQL?
ANSI?
SQL
SQL

- 2
SQL. .
""?



SQL
3. SQL

?
?
SELECT

SELECT




DISTINCT
ALL DISTINCT

- 2

SQL
4.



- 2
- 3
- 4

SQL
5.
IN
BETWEEN
BETWEEN - 2

LIKE
LIKE - 2
NULL
IS NULL
NOT

SQL
. 6
?
?

COUNT
DISTINCT
COUNT ,

,
GROUP BY
HAVING
HAVING - 2



SQL
8.




- 2





NULL

SQL
8. ,








SQL
9.
?






- 2

SQL
10.
?
,
DISTINCT


, IN

, IN - 2
, IN - 3


HAVING

SQL
11. Ѩ
Ѩ ?
?

? - 2
? - 3
Ѩ

Ѩ HAVING
Ѩ

SQL
12. EXISTS
EXISTS?

EXISTS
EXISTS Ѩ
EXISTS
NOT EXISTS
EXISTS

- 2

SQL
13. ANY, ALL SOME