:
DROP TABLE < 6>
, SALE :
DROP TABLE SALE
. , . , . , . , . :
CREATE [UNIQUE] INDEX < > N < > (< > [ ASC| DESC]
[,< > [ASC| DESC],...)
. .
UNIQUE . , UNIQUE .
ASC ( ), DESC. .
3.31.
CUST -. main_index - . :
CREATE INDEX main_index ON CUST (CUST_NAME)
:
DROP INDEX< >
. , , main_index CUST DROP INDEX main_index.
, , . "" , . , , . , . .
:
CREATE VIEW< >
[(< > [,< > ])]
AS < SELECT>
. , . , .
|
|
3.32.
c CUSTINF CUST, .
CREATE VIEW CUSTINF
AS SELECT CUST_NUM, CUST_NAME
FROM CUST
ORDER_CUS, 3105.
CREATE VIEW ORDER_CUS
AS SELECT
FROM ORDERS
WHERE CUST_NUM=3105
:
DROP VIEW < >
. , , , . ORDER_CUS :
DROP VIEW ORDER_CUS
.
3.33. GRAND REVOKE
GRAND REVOKE. ,
GRAND INSERT
ON CUST
TO PETROV
CUST.
REVOKE UPDATE, SELECT
ON CUST
TO IVANOV
SQL. SQL . SELECT, SQL-:
SELECT [ALL | DISTINCT]< >
FROM < >
[WHERE < >]
[GROUP BY < > [,< >]... ]
[HAVING < >]
[ORDER BY <> [,<>]...]
SELECT . SELECT , . . (ALL), (DISTINCT) . , . , , , ()
, FROM. .
: < >.< >.
WHERE , . WHERE < >. , , , (, , ), , LIKE ..
|
|
GROUP BY , . , GROUP BY. : AVG ( ), ( ), MIN ( ), SUM( ), COUNT ( ).
HAVING < >, , . < > WHERE.
ORDER BY . <> CREATE INDEX : < > [ ASC | DESC].
3.34.
. :
SELECT PROD_NAME, PRICE
FROM PROD
3.35.
, 100$. SELECT :
SELECT PROD_NAME
FROM PROD
WHERE PRICE>100
3. 36.
, , . SELECT ORDER BY, .
. . .