Infosys interview question

Database Question: how you'll remove duplicate entries from a given table.

Interview Answer

Anonymous

8 Nov 2020

We'll use primary key so that table don't have duplicate rows but even if we have to remove duplicate rows from selected table we use DISTINCT keyword.