Advertisement
Guest User

Untitled

a guest
Jul 20th, 2017
52
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.14 KB | None | 0 0
  1. SELECT s.name, s.gunSize
  2. FROM Ships s
  3. WHERE gunSize = (SELECT max(gunSize)
  4. FROM Ships s2
  5. WHERE gunSize < (SELECT MAX(gunSIZE) FROM Ships))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement