- () , . - .
, . , SQL XML , , . '- . () , . , . , .
51. ?
, . , . '- ò.
' - , . : () ', (. ). , .
Ͳ
52. .
53. - ?
54. - ?
55. - ?
56. - ?
1. - ?
2. - ?
57. - ?
. 㳿 ( ) , , . , , , (.. ). - , , , . ' , , .
|
|
: , . , (. , . , . ), , '- . ³ ' , , , : (. , . ), (. ), '- (. , . ). . CASE- (. , . ), XML- , XML , . CASE XML . , .
58. ?
䳿 , - , , ' . , .
: . ֳ .
- , ' , . , ' , .
|
|
59. - ?
: 1. . 2. . 3. . ᒺ G, - 3.4 . 3.23. - . 3.1 (. 3.1) ᒺ →. - ( ), - .
60. - ?
. , . - , 㳺 :
1. .
2. .
ᒺ G.
61. - ?
62. - ?
-. R110=(G,XA) . , . -, , :
R101=(G;|XT+) ' .
- ' R011=(XA|XT+) .
' R001=(|XT+) .
- .
63. - ?
, 㳺 :
1. .
2. .
' G.
3.24. - . 3.1 (. 3.1) , →(, ). , - , →(, ).
.
64. - ?
, 볿 . . , , - [18, 72]. , , [186]. - ' . , , . Â={R;P;S;Ω} - r Â. ( ), [18, 72]. , .
|
|
66. SELECT- SQL?
:
;
;
.
67. SELECT- SQL?
SELECT
FROM -
WHERE ;
SELECT . . , , .
-, - *.
SELECT name, surname
FROM student;
68. SELECT- SQL?
- DISTINCT
SELECT- DISTINCT ().
SELECT DISTINCT city
FROM student;
AND, OR, NOT
WHERE
= > >= < <= < >
AND, OR, NOT.
:
SELECT surname, name, city
FROM student
WHERE city= "" AND birthday > '1990-12-25';
IN
IN ( ) NOT IN ( ) .
,
SELECT *
FROM exam_marks
WHERE city IN ("", "");
,
SELECT *
FROM exam_marks
WHERE mark NOT IN (3, 5);
BETWEEN
BETWEEN
SELECT *
FROM subject
WHERE city BETWEEN "" AND "";
LIKE
, : _ , , % - , . ,
SELECT *
FROM student
WHERE surname LIKE %;
, ,
SELECT *
FROM subject
WHERE subj_name LIKE _%;
ORDER BY
ORDER BY . (ASC) (DESC). ,
SELECT *
FROM student
ORDER BY city;
:
SELECT *
FROM student
ORDER BY city DESC;
69. SQL-?
SQL- ϳ :
- ϳ (), ( ).
- ' , , .
|
|
- ϳ SQL-', , . SQL- , , SQL-'.