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 .
« | 1 2 3 | »