6
SQL
WHERE
SELECT, , SQL. , , . .
, . , ,
SELECT
: SELECT < >
FROM < > [ INTO < >
WHERE < >
GROUP BY < (), - >
HAVING < >
ORDER BY < >]
SELECT , . , *.
1. (, , ).
SELECT [], [ ], [ ], [ ]
FROM [];
, .
DISTINCT , SELECT.
DISTINCT SELECT. SELECT , , . , , , .
2. , ( ), .
| SELECT[ ] FROM; | SELECT DISTINCT[ ] FROM; | ||||||||||||||||||||||||||||||
:
| :
|
WHERE
WHERE SELECT (), , . , . WHERE , .
|
|
|
: WHERE ,
, . .
, : = (), >= ( ), > (, ), <= ( ), < (, ), <> ( ).
() - , , , . (/) (/).
: AND, OR, NOT.
. SQL : , , , .
