Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT name, employee_id
- FROM users u
- ,LATERAL (SELECT COUNT(*) FROM users u2 WHERE u.employee_id = u2.employee_id) AS s(c)
- WHERE c > 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement