, SQL, , .
SQL . ֳ SELECT, . , , , :
SELECT SFAM, SIMA, SOTCH, STIP*2 FROM STUDENTS;
:
SFAM | SIMA | SOTCH | |
51.00 | |||
34.00 | |||
0.00 | |||
0.00 | |||
51.00 |
, - , - , , , . , , SELECT . .. ' - , ' , .
. , , 䳿 - , :
SELECT SFAM, SIMA, SOTCH, 'y.e.', STIP*2 FROM. STUDENTS;
:
SFAM | SIMA | SOTCH | ||
.. | 51.00 | |||
.. | 34.00 | |||
.. | 0.00 | |||
.. | 0.00 | |||
.. | 51.00 |
, . , , , :
SELECT COUNT (DISTINCT SNUM), '. ', STIP, ' ..'
FROM STUDENTS GROUP BY STIP;
:
STIP | ||
2 . | 0.00 | .. |
1 . | 17.00 | . |
2 . | 25.00 | .. |
䳿 17.00 , , . , , SQL .
SQL ORDER BY, . , , (ASC) (DESC) . .
|
|
, :
SELECT * FROM STUDENTS ORDER BY SFAM ASC;
:
SNUM | SFAM | SIMA | SOTCH | |
0.00 | ||||
0.00 | ||||
25.50 | ||||
25.50 | ||||
17.00 |
. 䳿, , - . :
SELECT * FROM STUDENTS ORDER BY STIP DESC, SFAM ASC;
:
SNUM | SFAM | SIMA | SOTCH | |
25.50 | ||||
25.50 | ||||
17.00 | ||||
0.00 | ||||
0.00 |
ORDER BY - , - , , SELECT .