SELECT-
SELECT () SQL . . SELECT .
SELECT [DISTINCT] < >
FROM < >
[ WHERE < ]
[ GROUP BY < >]
[ HAVING <>]
[ UNION < SELECT >]
[ ORDER BY < >];
, .
SELECT , . SELECT ( ), .
- SELECT FROM (). FROM , .
,
SELECT NAME, SURNAME FROM STUDENT;
SQL- ";" ( ).
NAME SURNAME STUDENT.
:
NAME SURNAME, ; STUDENT.
, "*" ().
SELECT *
FROM STUDENT;
STUDENT.
, SQL- . , .
, " , , STUDENT", :
SELECT ClTY FROM STUDENT;
, ( ).
SELECT- DISTINCT (). SELECT , DISTINCT , .
" -roponoa, , STUDENT" .
SELECT DISTINCT CITY FROM STUDENT;
, :
ALL (), DISTINCT, , . . . , ALL, , .
|
|
SELECT , WHERE (), - (), ( NULL) , SELECT. WHERE , . , , , (); WHERE, .
.
, (NAME) (SURNAME) , STUDENT.
SELECT SURNAME, NAME
FROM STUDENT
WHERE SURNAME = ''
WHERE , : = (), > (), < (), >= ( ), <= ( ), <> ( ), AND, OR NOT.
, , ( ) :
SELECT NAME, SURNAME
FROM STUDENT
WHERE (KURS = 3 AND STIPEND > 0);
:
1. SUBJECT, () , , , , .
2. , - EXAM_MARKS, (SUBJ_ID), 12.
3. , STUDENT, : KURS, SURNAME, , STIPEND.
4. SELECT, (SUBJECT) (SUBJ_NAM) (HOUR) 4- (SEMESTR).
5. ,
EXAM_MARKS R ( ) , .
6. , , .
7. , , , 140.
8. , SUBJECT , 30 .
9. , . , 300 .
10. STUDENT w 100, - (SURNAME), (NAME) (KURS)
11. ?//
SELECT *
FROM STUDENT
WHERE (STIPEND < 100 OR
NOT (BIRTHDAY >= '#10/03/1980#'
AND STUDENT_ID > 1003));
12. . ? //
|
|
SELECT *
FROM STUDENT
WHERE NOT ((BIRTHDAY = '#10/03/1980#' OR STIPEND > 100)
AND STUDENT_ID) >= 1003);
13. 25 , 1- .
14. , 1- 100 .
15. , .
16. , , . .
17. , .
18. --20 .
19. .