Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT i FROM Table i JOIN i.other o
- SELECT i from Table WHERE id IN (
- SELECT id FROM (
- SELECT MIN(id) AS id, hash_of_i FROM Table GROUP BY hash_of_i
- ) t
- )
- SELECT i FROM Table i WHERE EXISTS (
- SELECT e FROM Table e JOIN e.other o WHERE e.id=i.id
- )
Add Comment
Please, Sign In to add comment