Advertisement
Guest User

Untitled

a guest
Apr 5th, 2020
185
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.33 KB | None | 0 0
  1. SELECT DISTINCT model FROM
  2. (SELECT model, price FROM PC
  3. UNION
  4. SELECT model, price FROM Laptop
  5. UNION
  6. SELECT model, price FROM Printer) AS tab
  7. WHERE price = (SELECT MAX(price) FROM
  8. (SELECT model, price FROM
  9. (SELECT model, price FROM PC
  10. UNION
  11. SELECT model, price FROM Laptop
  12. UNION
  13. SELECT model, price FROM Printer) AS tab1) AS tab2)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement