Finding Duplicate Rows in a Table

Question

I am trying to find out how many duplicate records I have in a table. I can use count, but I'm not sure how best to eliminate records where the count is only 1.

select first_name, last_name, start_date, count(1)
from employee
group by first_name, last_name, start_date;

I can try to order by the count, but I am still not eliminating those with a count of one.

Barbaros Özhan · Accepted Answer · 2019-11-06 19:58:48Z

5

you can use having clause as having Count(*) > 1 after group by like this :

select 
  first_name, 
  last_name, 
  start_date,
  Count(*) AS Count
from 
  employee 
group by 
  first_name, 
  last_name, 
  start_date
having 
  Count(*) > 1

edited Nov 6, 2019 at 19:58

Barbaros Özhan

65.9k11 gold badges36 silver badges64 bronze badges

answered Nov 6, 2019 at 19:52

mhd.cs

7212 gold badges10 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Finding Duplicate Rows in a Table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related