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