Advertisement
Guest User

Untitled

a guest
Jun 17th, 2019
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.14 KB | None | 0 0
  1. SELECT name, employee_id
  2. FROM users u
  3. ,LATERAL (SELECT COUNT(*) FROM users u2 WHERE u.employee_id = u2.employee_id) AS s(c)
  4. WHERE c > 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement