SQL1


         

SQL1

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
UNION ORDER BY

- 2
- 3

SQL

15. ,
DML

NULL
(INSERT)




UPDATE


NULL-

SQL
16.
INSERT

,
DELETE
DELETE - 2

UPDATE
DML

SQL
17.



:


,


SQL
18.


(NULL)
,






CHECK
,

- 2

SQL

19.



/FOREIGN KEY




?



, ?


- 2
- 3
, ͨ
, ͨ - 2


SQL
20. . .
?
CREATE VIEW
CREATE VIEW - 2







?


SQL
21.


__.
?

,
ר
,

SQL
22. ?





GRANT
. .

ALL PUBLIC
WITH GRANT OPTION


?
? - 2
? - 3





SQL
23. SQL





?
? - 2
?
? - 2
SQL ?
:
: - 2

- 2



SQL
24. SQL ?