MedeAnalytics interview question
Find duplicate rows in a table.
Interview Answer
Anonymous
11 Mar 2018
select id,count(id) from students group by id having count(id)>1 The above query helps to display records with id mentioned more than 1 time.
Find duplicate rows in a table.
Anonymous
select id,count(id) from students group by id having count(id)>1 The above query helps to display records with id mentioned more than 1 time.
Check out your Company Bowl for anonymous work chats.