MedeAnalytics Interview Question: Find duplicate rows in a tabl... |

Interview Question

Big Data/Big Data Engineer Interview Dallas, TX (US)

Find duplicate rows in a table.


Interview Answer

1 Answer


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.

Ishrath Sharffuddin on 11-Mar-2018

Add Answers or Comments

To comment on this, Sign In or Sign Up.