SQL


         

SQL


" "?


( )



- 2

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
ANY SOME
IN EXISTS ANY
IN EXISTS ANY - 2
ANY ?
ANY ? - 2

ANY ? - 3
ALL

ANY ALL
ANY, ALL EXIST ?
?
ANY ALL EXISTS NULL
COUNT EXISTS

SQL

14. UNION

?
UNION
UNION

- .
Corel 11 .


-

-
Windows -
- - 2 -
Windows -
Windows - 2 -
Windows - 3 -
-
-
- 2 -
- 3 -

- 4 -
- 5 -
Word 2000 -
-