NSETECH interview question

How to find duplicate elements in table

Interview Answer

Anonymous

12 July 2017

select column_name, count(column_name) from table group by column_name having count (column_name) > 1;