. SELECT :
SELECT [DISTINCT | ALL ]
{ * | <1> [,<2> ], <1>[AS <_>] }
FROM <1> [, <2> ]
:
SELECT R.*, T.ZENA, R.KOLVO*T.ZENA AS STOIM
FROM RASHOD R, TOVARY T
WHERE R.TOVAR = T.TOVAR
------------------------
AS STOIM
. :
COUNT(<>) ;
SUM(<>) ;
AVG(<>) ;
MAX(<>) ;
MIN(<>)- .
:
SELECT COUNT(DISTINCT POKUP) AS COUNT_POKUP
FROM RASHOD;
-----------------------
SELECT SUM(R.KOLVO*T.ZENA) AS OBS_ZENA
FROM RASHOD R, TOVARY T
WHERE (R.TOVAR = T.TOVAR)
, , - . WHERE :
GROUP BY [, 1 ]
:
SELECT R.TOVAR, SUM(R.KOLVO*T.ZENA)
FROM RASHOD R, TOVARY T
WHERE R.TOVAR = T.TOVAR
GROUP BY R.TOVAR, R.DAT_RASH
---------------------------------------------------
SELECT DAT_RASH, COUNT(DISTINCT POKUP)
FROM RASHOD
GROUP BY DAT_RASH
, , GROUP BY :
HAVING < > <> <>
MIN, MAX, AVG, SUM
.
, , SELECT.
:
SELECT POKUP, MIN(KOLVO)
FROM RASHOD
GROUP BY POKUP
HAVING MIN (KOLVO) >= 100
HAVING WHERE:
HAVING ;
WHERE , ;
WHERE .
3.4.1.11. SELECT: .
AND, OR NOT.
|
|
:
, , .
:
SELECT R.*, T.ZENA
FROM RASHOD R, TOVARY T
WHERE R.TOVAR = T.TOVAR AND
(R.KOLVO <= 30 OR R.KOLVO >= 3000) AND
R.POKUP IS NOT NULL
ORDER BY R.KOLVO
<> <> <>
<> <> <>
.
:
SELECT R.DAT_RASH, R.TOVAR, T.ZENA
FROM RASHOD R, TOVAR T
WHERE R.TOVAR = T.TOVAR AND T.ZENA > (120 / R.KOLVO)
ORDER BY R.DAT_RASH
BETWEEN
<> [ NOT ] BETWEEN <1> AND <2>
, 1 2.
:
SELECT *
FROM RASHOD
WHERE KOLVO BETWEEN 1000 AND 3000
IN
, - ( ) , :
<> [ NOT ] IN (<1> [, <2> ])
, , IN, , .
:
SELECT *
FROM RASHOD
WHERE KOLVO IN (100, 1000, 3000)
:
IN, SELECT.