Advertisement
Dyrcona

dup usrnames

Mar 31st, 2020
853
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. select a.id, a.usrname, b.id, b.usrname
  2. from actor.usr a
  3. join actor.usr b
  4. on lower(b.usrname) = lower(a.usrname)
  5. and b.id > a.id
  6. and not a.deleted and not b.deleted;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement