how to delete duplicate rows from table in sql server

Question Posted / k l baiju

12 Answers
23199 Views
HCL, UHG, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to delete duplicate rows from table in sql server..

Answer / suresh s

delete tblname where columname in (select columnname
FROM tblname GROUP BY columnname having count(columnname)
>=2)

Is This Answer Correct ?

25 Yes

30 No

how to delete duplicate rows from table in sql server..

Answer / swapna

We can delete duplicate rows from table by using distinct
command.

Is This Answer Correct ?

10 Yes

35 No

Post New Answer

More SQL Server Interview Questions

How to retrieve data from log files in SQL SERVER ?????

1 Answers

Explain the different types of backups available in sql server? : sql server database administration

0 Answers

How to view existing indexes on an given table using sp_help?

0 Answers

i have account table which consists of account name,card no and card no consists 16 digits now i want to retrieve the data if card no starts from 4 then it should print visa and if it starts from 5 then it should print master so plse help me to write simple query with out store procs .

3 Answers

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

0 Answers

State a few properties of relational databases?

0 Answers

Is it possible to delete duplicate rows in a table without using a temporary table ?

12 Answers TCS,

Why SQL Agent is used?

0 Answers Abacus,

Questions regarding Raiseerror?

1 Answers

Explain the purpose of indexes?