SELECT
.
SELECT
SELECT [DISTINCT | ALL ] {* | <1> [,<2> ]}
FROM <1> [, <2> ]
[ WHERE <_> ]
[ GROUP BY [, 1 ]
[ HAVING < _> ]
[ UNION <_select>]
[ PLAN <__>]
[ ORDER BY <_>]
:
SELECT { * | <1>, <1> [,<2> ]}
FROM <1> [, <2 ]
:
SELECT *
FROM RASHOD
:
SELECT N_RASH, DAT_RASH, KOLVO, TOVAR, POKUP
FROM RASHOD
WHERE
WHERE .
:
SELECT {* | <1> [,<2> ]}
FROM <1> [, <2> ]
[ WHERE <_> ]
:
< > = <> <>
<> - :
<> = { = | < | > | <= | >= |!= |!< |!> | <> }
:
SELECT * FROM RASHOD WHERE KOLVO = 20
WHERE. .
:
< > = < 1> <> < 2>
:
RASHOD TOVARY, :
SELECT RASHOD.*, TOVARY.ZENA
FROM RASHOD, TOVARY
WHERE RASHOD.TOVAR = TOVARY.TOVAR
.
A B .
1. , SELECT, .
2. , WHERE.
:
SQL- .
:
A
| . P1 | . P2 | . P3 |
| a | x | |
| b | x | |
| c | y | |
| d |
B
| . P1 | . P2 |
| x | |
| y | |
| z |
SELECT A.P1, A.P2, B.P2
FROM A, B
WHERE A.P2 = B.P1
| . A.P1 | . A.P2 | . B.P1 | . B.P2 |
| a | x | x | |
| a | x | y | |
| a | x | z | |
| b | x | x | |
| b | x | y | |
| b | x | z | |
| c | y | x | |
| c | y | y | |
| c | y | z |
|
|
|
| . A.P1 | . A.P2 | . B.P2 |
| a | x | |
| b | x | |
| c |
SELECT
FROM < 1 1> [, 2 2 ]
WHERE
:
SELECT R.*, P.ADRES
FROM RASHOD R, POKUPATELI P
WHERE P.POKUP = R.POKUP
3.4.1.5. ORDER BY
:
ORDER BY <_>
:
SELECT POKUP, DATRASH, TOVAR, KOLVO
FROM RASHOD
WHERE TOVAR = -
ORDER BY POKUP, DATARASH
.
DISTINCT
:
SELECT DISTINCT TOVAR
FROM RASHOD
:
DISTINCT , .. . , .
