Advertisement
saleks28

Untitled

Sep 23rd, 2020
307
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.63 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 Software_Code
  7. FROM Software_Computer_System WHERE Software_Computer_System.CS_Code=CS1.Code
  8. MINUS
  9. SELECT Software_Code
  10. FROM Software_Computer_System WHERE Software_Computer_System.CS_Code=CS2.Code)
  11. UNION
  12. (SELECT Software_Code
  13. FROM Software_Computer_System WHERE Software_Computer_System.CS_Code=CS2.Code
  14. MINUS
  15. SELECT Software_Code
  16. FROM Software_Computer_System WHERE Software_Computer_System.CS_Code=CS1.Code)
  17. )) AND CS2.Code>CS1.Code;
  18.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement