:
UPDATE P SET PNAME = "" WHERE P.PNUM = 1;
30. .
SELECT [ ].[ ]
FROM [ ],
WHERE id_=(select id from where .=' ');
. , . , , , . , .
- . select, .
IN
IN ()
SELECT *
FROM Salespeople
WHERE city = 'Barcelona'
OR city = 'London';
:
SELECT *
FROM Salespeople
WHERE city IN ('Barcelona', 'London');
, , . . .
:
IN - ;
SOME - , ;
ALL - C , .
, , IN.
IN ()
SELECT *
FROM Salespeople
WHERE city = 'Barcelona'
OR city = 'London';
:
SELECT *
FROM Salespeople
WHERE city IN ('Barcelona', 'London');
: - , .
2 Sale Tovar
SQL |
SELECT S.ID, S.Sum_sale, S.Number_sale, S.Date_sale, T.NameTovar FROM Tovar T, Sale S WHERE T.ID = S.Tovar_ID AND S.Tovar_ID IN (SELECT Tovar_ID FROM Sale WHERE Sum_Sale = (SELECT MAX(Sum_Sale) FROM SALE)) ORDER BY S.Sum_Sale DESC |
: (SELECT MAX(Sum_Sale)) (16500). (SELECT Tovar_ID .) (4,5), . ID 16500. , :
|
|
SELECT S.ID, S.Sum_sale, S.Number_sale, S.Date_sale, T.NameTovar FROM Tovar T, Sale S WHERE T.ID = S.Tovar_ID AND S.Tovar_ID IN (4, 5) |
ALL, SOME , ( , ) , , : < > {[NOT]} <> {ALL|SOME|ANY} (<>) . (>, >=,<,<= .). , ALL ANY (SOME). ALL , . >ALL - , <ALL - , , ALL , , , , , . : WHERE Column >ALL (SELECT Field FROM Table) , Column Field Table. : , , : SQL |
SELECT S.ID, S.Sum_sale, S.Number_sale, S.Date_sale, T.NameTovar FROM Tovar T, Sale S WHERE T.ID = S.Tovar_ID AND S.Sum_sale > ALL (SELECT AVG(Sum_Sale) FROM SALE GROUP BY Tovar_ID) |
ANY SOME , . <ANY - , >ANY - , =ANY IN .. ANY ( SOME) , , , , , . : WHERE Column >ANY (SELECT Field FROM Table) , Column Field Table. : , , : SQL |
SELECT S.ID, S.Sum_sale, S.Number_sale, S.Date_sale, T.NameTovar FROM Tovar T, Sale S WHERE T.ID = S.Tovar_ID AND S.Sum_sale > ANY (SELECT AVG(Sum_Sale) FROM SALE GROUP BY Tovar_ID) |
35. ..
. SELECT WHERE
GROUP BY [, 1 ]
GROUP BY .
SELECT, , GROUP BY. GROUP BY , .
WHERE .
GROUP BY .
GROUP BY .
, GROUP BY, ORDER BY.
GROUP BY, , SELECT, , GROUP BY.
, GROUP BY, SELECT.
|
|
: :
SQL |
SELECT T.NameTovar, SUM(S.Number_sale) AS Gen_Number_Sale FROM Sale S, Tovar T WHERE S.Tovar_ID = T |
GROUP BY T.NameTovar
SQL |
SELECT T.NameTovar, SUM(S.Number_sale*T.Price) AS Gen_Sum FROM Sale S, Tovar T WHERE S.Tovar_ID = T.ID GROUP BY T.NameTovar |
, , , , WHERE, ORDER BY < > , . , , , , , , , , .. : , . SQL |
SELECT * FROM Sale ORDER BY Number_sale |
: , 3000 :
SQL |
SELECT * FROM Sale WHERE Sum_Sale > = 3000 ORDER BY Date_sale |
: , , .
SQL |
SELECT * FROM Sale ORDER BY Date_sale, Sum_sale |
Int- 4
Double-
Float-
Bool-
String-
Byt-
Char-
- , .
- CHAR CHAR(n) - . n. CHAR CHAR(1). n .
- VARCHAR(n) - . , .
- - ( ). ( , , ).
- INTEGER INT - , , , 4 . (: , , "" ) - 2147483647 + 2147483648
- SMALLINT - (2 ), - 32767 +32768
- - .
- FLOAT SMALLFLOAT - ( 8 4 ).
- DECIMAL(p) - FLOAT p.
- DECIMAL(p,n) - , p - , n - .
- - , , . , DECIMAL(p,n).
- MONEY(p,n) - DECIMAL(p,n). , .
- - , . , .
- DATE - .
- TIME - .
- INTERVAL - .
- DATETIME - ( + + + + + + ).
- - ( , ..). , :
- BINARY
- BYTE
- BLOB
- - .
- SERIAL - INTEGER, (, ). , .
,
|
|