SELECT < 1> FROM < >
WHERE <> ORDER BY < 2>
< 1> - , ,
< >- , , ,
<> - , ,
< 2> - , , .
5.1. ,
|
SELECT id, name, cost, FROM detail
1. , *. SELECT * FROM Detail.
5.2. 2 , ,
SELECT name, cost FROM detail
2. , .
5.3. , .
SELECT name, cost*1000 FROM detail
3. , . AS.
5.4. 3, .
SELECT name AS [], Cost*1000 AS [ ] FROM detail
|
. :
=
>=
>
<
<=
<>
OR
AND
IN
LIKE
BETWEENAND
5.5. , 1
SELECT name FROM detail WHERE cost >1
5.6. , .
SELECT name FROM detail WHERE name LIKE %
SELECT name FROM detail WHERE upper (name) LIKE %
4. , .
5. 6 , , , UPPER , .
5.7. , 0,5 1.
|
|
SELECT * FROM detail WHERE cost BETWEEN 0.5 AND 1.
5.8.
SELECT * FROM detail WHERE name IN (,).
ORDER BY , . , . , . , . - , DESC.
5.9. Detail, .
SELECT * FROM detail ORDER BY cost, name DESC
6. , . DISTINCT, SELECT
5.10. , .. . , . DISTINCT.
SELECT DISTINCT name FROM detail ORDER BY name