Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select a.id, a.usrname, b.id, b.usrname
- from actor.usr a
- join actor.usr b
- on lower(b.usrname) = lower(a.usrname)
- and b.id > a.id
- and not a.deleted and not b.deleted;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement