UPDATE SQL. . |
. .
-101 -102 UPDATE studs SET n_grupa = 2 WHERE c_fio_stud = "" AND n_grupa=1. UPDATE TABLE "table_name" SET ("column_1", "column_2") = ([new value 1], [new value 2]) WHERE {condition}. UPDATE grups SET n_men ( SELECT count(*) FROM studs WHERE studs.n_grupa=grups.n_grupa )
3. CASE – . ERWin, BPWin
CASE- . - , CASE- -, , , . . CASE- - , , , .
" ":
1 - . .
2 -
...
9 - 6 . , , , .
10 - SELECT SQL. IN, SELECT.
11 - UPDATE SQL. .
12 - ( -; ; ;
13 - SELECT SQL. (ORDER BY). (GROUP BY, GROUP BY HAVING).
...
43 - .
44 - - . .
45 - .
| : |
