Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select t
- from (select t.*,
- count(*) over (partition by soundex(fname), soundex(lname), dob) as cnt
- from t
- ) t
- where cnt > 1
- order by dob, fname, lname;
- count(*) over (partition by substring(soundex(fname),0,3), substring(soundex(lname),0,3), dob) as cnt
- Ana
- Annette
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement