1. | . |
, , . . , . , , . , , , . CREATE VIEW.
:
CREATE VIEW
AS SELECT * FROM
WHERE = 2;
, , , , , .
, . , . . :
SELECT * FROM
WHERE > 1200000;
:
SELECT * FROM
WHERE = 2
AND > 1200000;
SQL , , f GROUP BY . , , , , :
CREATE VIEW
AS SELECT , COUNT(DISTINCT )
FROM GROUP BY ;
:
SELECT * FROM ;
. , , :
CREATE VIEW
AS SELECT ,a. As ,,,,,,c. As
FROM a, b, c
WHERE a. = b.
AND b. = c.;
SELECT * FROM
WHERE = ;
, . :
SELECT a.sname, cname, ame*comm.
FROM a, b
WHERE a. =
AND b. = a.;
, . , , . :
CREATE VIEW Esf
AS SELECT , ,
FROM
WHERE = (
SELECT MAX()
FROM );
SELECT * FROM Esf;
DROP VIEW < >.
|
|
, , , . DROP .
2. | . |
: . :
1. | . |
2. | . |
3. | , . |
4. | DISTINCT . |
5. | GROUP BY HAVING . |
6. | . |
7. | . |
8. | , . |
9. | INSERT , NOT NULL. |
, , . , . :
CREATE VIEW Highrating
AS SELECT cnum, rating FROM Customers
WHERE rating = 300;
:
INSERT INTO Highrating
VALUES (2000, 200);
. SQL : :
WITH CHECK OPTION
. . . , , , :
CREATE VIEW Londonstaff
AS SELECT cnum, cname, comm
FROM Salespeople
WHERE city =London;
, , . , , .
, city. :
SELECT snum, sname
FROM Londonstaff;
WITH CHECK OPTION , , , . :
CREATE VIEW Highrating
AS SELECT cnum, rating FROM Customers
WHERE rating = 300
WHITH CHECK OPTION;
, 300 , :
CREATE VIEW Vyrating
AS SELECT *
FROM Highrating;
UPDATE Murating
SET rating = 200
WHERE cnum = 2004;
ER-
3. | - |
"" (entityrelation, ERmethod) . . , ( ) , (). , .
|
|
. , 6 - 7 .
, . (, ), (, ).
. , .
. , . , , , . (), (, ).