Pregunta de entrevista de MedeAnalytics

Find duplicate rows in a table.

Respuesta de la entrevista

Anónimo

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.