:
WHERE () , ( );
GROUP BY ( ) ;
HAVING (, ) , ( );
ORDER BY ( ) (). , :
SELECT
FROM
WHERE
GROUP BY
HAVING
ORDER BY ;
SQL- . . , SQL- , :
1. FROM ; , .
2. WHERE , , .
3. GROUP BY , WHERE ( SQL-); - . , FROM, , SELECT.
4. HAVING , , ; GROUP BY.
5. SELECT , , .
6. ORDER BY . , SELECT.
SQL-:
SELECT , FROM WHERE > 500;
, > 500;
, 500, , . , , , . , .
SELECT , , FROM
WHERE > 500
GROUP BY , ,
ORDER BY ;
WHERE
WHERE () , . . -. true () false (). , > 500 (
|
|
true), 500. ( false). . , SQL . , NULL. , SQL , .
, , WHERE, : true, false NULL. (SQL-) WHERE . , ; - .
, . , _ > 500 (>).
, (=), (<), (>), (<>), (<=) (>=). . :
: (=), (<), (>), (<>), (<=), (>=);
BETWEEN;
IN, NOT IN;
LIKE, NOT LIKE;
IS NULL;
ALL, SOME, ANY;
EXISTS;
UNIQUE;
DISTINCT;
OVERLAPS;
MATCH;
SIMILAR
, , .
= | |
<> | |
< | |
<= | ( ) |
> | |
>= | ( ) |
BETWEEN
BETWEEN () - , . :