Advertisement
Guest User

Untitled

a guest
Jun 18th, 2019
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.21 KB | None | 0 0
  1. SELECT u FROM USER u JOIN SIGNATURES s WHERE s.name like "Math" AND "Languages"
  2.  
  3. SELECT u FROM USER u JOIN SIGNATURES s
  4. WHERE s.name IN List<String>
  5. GROUP BY s.id
  6. HAVING COUNT(s.id) = list.length
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement