 |
Alis |
.grande:maestro.
Registered: Jun 2002
Posts: 862 (0.10 al dì)
Location: Corsico
Corso:
Anno:
Time Online: 10 Days, 16:32:12 [...]
Status: Offline
Edit | Report | IP: Logged |
Noi l'abbiamo rifatto così:
13/01/03:
Esercizio 1/C:
SELECT CodFornitore
FROM Computer
GROUP BY CodFornitore
HAVING COUNT (*) >= ALL (SELECT COUNT (*) FROM Computer GROUP BY CodFornitore);
Esercizio 3:
CREATE TABLE R1(K Integer not null, A Integer)
PRIMARY KEY (K);
CREATE TABLE R2(K Integer not null, B Integer)
PRIMARY KEY (K);
INSERT INTO R1(K, A)
SELECT K, A
FROM R;
INSERT INTO R2(K, B)
SELECT K, B
FROM R;
DROP TABLE R;
CREATE VIEW R(K, A, B) AS
SELECT R1.K, A, B
FROM R1, R2
WHERE R1.K=R2.K;
GRANT SELECT ON R TO Rossi;
In bocca al lupo per domani!!!!
|
Vale
