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

Interview Question

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

Find duplicate rows in a table.

Answer

Interview Answer

1 Answer

0

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.