CREATE SCHEMA - DROP SHEMA - CREATE TABLE - ALTER TABLE - DROP TABLE - CREATE DOMAIN - ALTER DOMAIN - DROP DOMAIN - CREATE COLLATION - DROP COLLATION - CREATE VIEW - DROP VIEW -
DML (Data Manipulation Language) -
SELECT - INSERT - UPDATE - DELETE - COMMIT - ROLLBACK -
CREATE ASSERTION - DROP ASSERTION - GRANT - REVOKE -
, , , SQL, SQL.
31. SELECT
SELECT SQL. , .. , , - .
32. WHERE SELECT * FROM P WHERE P.PNUM > 2;WHERE , , , (>, <, = ..), , AND OR, NOT.
33. SELECT
, ( DISTINCT):
SELECT DISTINCT P.NAME
FROM P;
( AS ):
SELECT
TOVAR.TNAME,
TOVAR.KOL,
TOVAR.PRICE,
"=" AS EQU,
TOVAR.KOL*TOVAR.PRICE AS SUMMA
FROM TOVAR;
( ORDER BY ):
SELECT
PD.PNUM,
PD.DNUM,
PD.VOLUME
FROM PD
ORDER BY DNUM;
.
SELECT , , ' -', (SUM(INT((+)*4.1+*9.3)*/1000)), (SUM(/_*/1000)+MIN(/100)),▓▓FROM , _, , , WHERE . = .AND . = .AND . = .AND . = _.AND NOT IN (SELECT FROM WHERE IN (SELECT FROM WHERE _ = 0))GROUP BY , HAVING SUM(/_*/1000+MIN(/100)) < 1.5 AND SUM(((+)*4.1+*9.3)*/1000) < 400ORDER BY , 4;
34
SQL . : =, < >, < >.
SELECT *
FROM PRODOCTS_TBL
WHERE PROD ID = '2345';
|
|
|
BETWEEN , . .
SELECT *
PRODUCTS_TBL
WHERE COST BETWEEN 5.95 AND 14.5;
IN
IN . TRUE, .
WHERE SALARY IN ('20000', '30000', '40000')
20000, 30000
40000
LIKE
LIKE (wildcards).
(%)
(_)
WHERE SALARY LIKE '200%' ,
200; 200
WHERE SALARY LIKE '_00% ' , 00
WHERE SALARY LIKE ' 2 % % ' , 2
WHERE SALARY LIKE '_2%3' , 2
3
37. NULL- WHERE.
, , -
| SELECT DISTINCT FROM WHERE _ IS NULL; | ||
SELECT DISTINCT
FROM
WHERE _ IS NULL -
