Bazy_dannykh_Uchebnoe_posobie
.pdf+ ORDER BY
+ GROUP BY
HAVING
34.?
FROM
+ WHERE
ORDER BY
GROUP BY
HAVING
SELECT
35.?
+ FROM
WHERE
+ ORDER BY
+ GROUP BY
+ HAVING
+ SELECT
36.
?
+ +
+ + + +
37. SELECT?
+
191
38. SELECT
?
FROM
WHERE
ORDER BY
GROUP BY
HAVING
+ SELECT
39. SELECT ?
FROM
+ WHERE
ORDER BY
GROUP BY
HAVING
SELECT
40. SELECT
?
+ FROM
+ WHERE ORDER BY GROUP BY HAVING
+ SELECT
41. SELECT
?
FROM
+ WHERE ORDER BY GROUP BY
192
HAVING
SELECT
42. SELECT
?
+ . .
43. INSERT?
+
44. INSERT
?
INSERT
+ VALUES FROM WHERE
45. INSERT?
FROM
WHERE
+ VALUES
GROUP BY
46. DELETE?
+ FROM
+ WHERE
193
VALUES
GROUP BY
47. DELETE ?
,
+ +
48. DELETE
?
FROM
+ WHERE DELETE SET
49. ()
?
INSERT
+ SELECT ORDER BY GROUP BY HAVING
50. ()
?
INSERT
+ SELECT ORDER BY GROUP BY HAVING
51. ()
?
194
+FROM
+WHERE ORDER BY GROUP BY HAVING
+SELECT
195
5. ()
1. "-" ____
.
+
2. ER-
?
+
3. , ER-
?
+ ,
,
ER-
4. ER-?
+ + +
5. ER-
+
196
+ +
+
6. ER-?
+
7. ?
+ +
+
+
8. «»?
+ +
9. «»?
+ +
10.
?
197
+ +
ER-
11.
?
+ +
+ +
12. ?
+
13.
?
+
+
+
14.
?
+
+
+
198
15. ?
+
+
16. ?
+ +
+
17. X Y?
+ X Y
+ X, Y Y X
Y X
Y X
Y, X
18. ?
+ + +
19. ?
+
199
+
20. ?
+ ,
,
,
21. ?
+
22. ?
+
23. ?
,
200