Guest User

Untitled

a guest
Jan 12th, 2016
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.29 KB | None | 0 0
  1. SELECT
  2. COUNT(*) as number
  3. FROM
  4. (
  5. SELECT
  6. f.id as id2
  7. FROM
  8. final_car_user f
  9. INNER JOIN final_car_user f1 ON f.first_name = f1.first_name
  10. AND f.last_name = f1.last_name
  11. group by
  12. (f.id)
  13. HAVING
  14. count(f1.id) > 1
  15. ) as t1
Add Comment
Please, Sign In to add comment