WHERE , . , , . , , , , LIKE, NULL, IN .
SELECT (*/(.1),(.2)/)- .
FROM (.1),(.2) - ()
WHERE ( ())
SELECT , , FROM .
, :
<1> < > <2>
, , , , . .
:
SELECT Rashod.*, Tovary.Cena
FROM Rashod, Tovary
WHERE Rashod.Tovar=Tovary.Tovar, Rashod.Kolvo<20
:
1) , SELECT, .
2) , WHERE.
SELECT .
. , , ORDER BY. . , ( ). , , . . ( . ).
SELECT Pokup, Data_Rash, Kolvo, Tovar
FROM Rashod
ORDER BY Pokup, Data_Rash
WHERE :
SELECT Pokup, Data_Rash, Kolvo, Tovar
FROM Rashod
WHERE Tovar=
ORDER BY Pokup
. - DESC.
.
, . SELECT DISTINCT.
SELECT DISTINCT/ALL {*/(.1),(.2)}
FROM (.1),(.2)
, ALL.
, , :
SELECT DISTINCT Tovar
FROM Rashod
DISTINCT , .. DISTINCT , . :
- AVG () . - MAX ()
- MIN () - . - SUM () -
- COUNT ()
- COUNT (*)
1)
SELECT COUNT (DISTINCT Pokup) as COUNT Pokup
FROM Rashod
2)
SELECT SUM (R.Kolvo*T.Cena) as ABS_CENA
FROM Rashod R, Tovary T
WHERE (R.Tovar=T.Tovar) AND (R.DAT_RAS=18.03.10)
3)
SELECT R.Tovar, SUM (R.Kolvo*T.Cena)
FROM Rashod R, Tovary T
WHERE (R.Tovar=T.Tovar)
Group By R.Tovar, R.Data_Rash