Elavon interview question

How will you identify duplicates on any table?

Interview Answer

Anonymous

26 Apr 2023

select id, count(1) from the table having count(1) >1