Advertisement
saleks28

Untitled

Sep 23rd, 2020
298
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.53 KB | None | 0 0
  1. SELECT CS1.Code Code1, CS2.Code Code2
  2. FROM Computer_System CS1, Computer_System CS2
  3. WHERE
  4. (NOT EXISTS
  5. (
  6. (SELECT Code_Software
  7. FROM Software_CS WHERE Software_CS.Code_CS=CS1.Code
  8. MINUS
  9. SELECT Code_Software
  10. FROM Software_CS WHERE Software_CS.Code_CS=CS2.Code)
  11. UNION
  12. (SELECT Code_Software
  13. FROM Software_CS WHERE Software_CS.Code_CS=CS2.Code
  14. MINUS
  15. SELECT Code_Software
  16. FROM Software_CS WHERE Software_CS.Code_CS=CS1.Code)
  17. )) AND CS2.Code>CS1.Code;
  18.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement