AND
- AND ;
OR
- OR ;
AND NOT
- ;
OR NOT
- ,
AND OR ( AND OR). WHERE , .
- , , . , , , ASCII. , , , .
, GROUP BY
GROUP BY [.] [,[.]]... [HAVING ]
GROUP BY , -, GROUP BY. , SELECT, (, ..).
HAVING ( WHERE)
HAVING [NOT] HAVING_ [[AND|OR][NOT] HAVING_]...
, :
{ = | <> | < | <= | > | >= } { | ()
| SQL_ }
{_1 | SQL__1} [NOT] BETWEEN
{_2 | SQL__2} AND {_3 | SQL__3}
{ | SQL_} [NOT] IN { ( [,]...)
| () }
{ | SQL_} IS [NOT] NULL
[.] [NOT] LIKE '_' [ESCAPE '']
EXISTS ()
2.2. WHERE
,
SELECT , ,
FROM ;
, . 2.1,.
,
SELECT , , , , ,
FROM ;
:
SELECT *
FROM ;
"" (*) , FROM. , .
. :
SELECT
FROM ;
, . 2.1,.
) | ) | ) | |||||||||||||||||||||||||||||||||||||||||||||||
|
|
. 2.1.
|
|
, : . DISTINCT (, ), :
SELECT DISTINCT
FROM ;
. 2.1,.
2.2.3.
SELECT (.2.1) , *, .
, , , 1 4.1 , 1 - 9.3 , :
SELECT , ((+)*4.1+*9.3)
FROM ;
. 2.2,.
) | ) | ) | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
. 2.2.
SELECT , . , ('). . 2.2, :
SELECT , ' =', ((+)*4.1+ *9.3)
FROM ;
, - , .. NULL ?
- - , NULL-. NULL- "" , " " . , , , , . : , - . NULL- - : , ( ) -0-.
|
|
NULL- : NULL- . , , . ( ).
,
SELECT , , _, ( * _)
FROM ;
"" :
|
|
2.3. c WHERE
WHERE (.2.1) , = (), <> ( ), < (), <= ( ), > (), >= ( ), NOT, , , " " " ".
, , ,
SELECT , , , , K, Ca, Na, B2, PP, C
FROM
WHERE = 0;
:
K | Ca | Na | B2 | PP | C | ||||
189. | 124. | 0. | 1.5 | 28. | |||||
190. | 80. | 0. | 270 0 | 1.1 | 10. |
, AND, OR, AND NOT OR NOT, . , , , :
SELECT , , , , K, Ca, Na, B2, PP, C
FROM
WHERE = 0 AND Na = 0;
K | Ca | Na | B2 | PP | C | ||||
190. | 80. | 0. | 1.1 | 10. |
SELECT , , , , K, Ca, Na, B2, PP, C
FROM
WHERE = 0 AND Na = 0 AND <> '';
"No rows exist or satisfy the specified clause" ( ), , () ().
2.3.2. BETWEEN
BETWEEN... AND... ( ... ...) , - .
, , 10 50:
: | ||
SELECT , FROM WHERE BETWEEN 10 AND 50; | ||
31. | ||
26. | ||
28. | ||
13. | ||
17. |
NOT BETWEEN ( ), :
: | |||
SELECT , , FROM WHERE NOT BETWEEN 10 AND 50 AND > 100; | |||
189. | 124. | ||
60. | 825. | ||
127. | 115. |
BETWEEN , , .
|
|
" " (. 2.1), . 9 9999 .
2.1
01-01-1993 | 31-03-1993 | |
01-04-1993 | 30-06-1993 | |
01-07-1993 | 30-11-1993 | |
01-12-1993 | 30-06-1994 | |
01-07-1994 | 09-09-9999 |
, , , 1993/94 ,
SELECT ,
FROM
WHERE BETWEEN '1-9-1993' AND '31-8-1994'
:
01-12-1993 | |
01-07-1994 |
, , 31 8, 1994.
, 1993/94 ,
SELECT *
FROM
WHERE BETWEEN '1-9-1993' AND '31-8-1994'
OR BETWEEN '1-9-1993' AND '31-8-1994'
01/07/1993 | 30/11/1993 | |
01/12/1993 | 30/06/1994 | |
01/07/1994 | 09/09/9999 |
, 15-5-1994:
: | ||
SELECT FROM WHERE '15-05-1994' BETWEEN AND | ||
2.3.3. IN
,
SELECT *
FROM
WHERE IN ( );
:
200. | |||||
200. | |||||
180. | |||||
260. | |||||
200. | |||||
210. | |||||
160. | |||||
260. |
IN , OR. :
SELECT *
FROM
WHERE = OR = OR =;
NOT IN ( ), IN (NOT IN) (. 3).
2.3.4. LIKE
: | ||
SELECT FROM WHERE LIKE '%'; | ||
"_ LIKE _" , , "_". :
- _ () ,
- % () N ( N ),
- .
, SELECT , '' , ''. " ", " " .., . WHERE:
|
|
WHERE LIKE '%%'
( ):
WHERE LIKE '%%'
.
2.3.5. (NULL-)
.2.2.3, - , NULL-. , . , _ NULL NULL-, 0, 0. . (, .1.1 , NULL- ).
, , -
: | ||
SELECT DISTINCT FROM WHERE _ IS NULL; | 2 9 |
, , ,
SELECT DISTINCT
FROM
WHERE _ IS NOT NULL;
IS NULL IS NOT NULL
, ,
= NULL <> NULL
, - NULL- - NULL-. ( , , , , SELECT DISTINCT NULL-.)
2.4.
. 2.1. - . ( .)
,
: | ||||||||||||||||||||||||||||||||||
|
| |||||||||||||||||||||||||||||||||
ORDER BY . ORDER BY ..
, , :
: | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
, ORDER BY , SELECT. , .
,
SELECT , ((+)*4.1+*9.3)
FROM
ORDER BY 2;
, .2.2, .2.2,.
2.5.
SQL-
SQL (SQL-). COUNT(*) , :
COUNT
- ,
SUM
- ,
AVG
- ,
MAX
- ,
MIN
- .
|
|
SUM AVG .
, - , , , () . , , , SQL- ( SQL- ). SQL- .
, COUNT(*), DISTINCT (), , , . COUNT(*) ( ).
2.5.2. GROUP BY
GROUP BY, _SELECT SQL- , . , , SQL-.
, (=10), , :
: | ||
SELECT SUM(_),COUNT(_) FROM WHERE = 10; | ||
SUM(_) | COUNT(_) | |
SELECT ,SUM(_),COUNT(_)
FROM
WHERE = 10;
. , SQL- -, "" . ( GROUP BY) SQL , ( , =10) ( WHERE ). .