Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --9.1
- CREATE TABLE user1_c AS SELECT * FROM Clients
- GROUP BY CNUM,CNAME,CITY,RATING,SNUM HAVING COUNT(*) = 1;
- --9.2
- CREATE TABLE user1_s AS SELECT * FROM Sales
- GROUP BY SNUM,SNAME,CITY,COMM HAVING COUNT(*) = 1;
- --9.3
- DELETE FROM user1_s o_s WHERE o_s.SNUM IN (SELECT SNUM FROM user1_s s GROUP BY SNUM HAVING COUNT(*) > 1);
- DELETE FROM USER1_S s WHERE s.SNUM IS NULL;
- ALTER TABLE user1_s ADD PRIMARY KEY (SNUM);
- --ALTER TABLE user1_s ADD CONSTRAINT PK_USER1_S PRIMARY KEY (SNUM);
- DESC user1_s;
- --9.4
- DELETE FROM USER1_C c WHERE c.SNUM IS NULL;
- DELETE FROM USER1_C WHERE SNUM NOT IN (SELECT SNUM FROM user1_s)
- ALTER TABLE user1_c ADD FOREIGN KEY (SNUM) REFERENCES USER1_S(SNUM);
- --9.4.5
- SELECT * FROM USER1_S s RIGHT JOIN USER1_C c ON s.SNUM = c.SNUM;
- -- 9.5
- DROP TABLE USER1_C;
- DROP TABLE USER1_S;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement