delete from table name having count(column name)>1 group by column nam

How to delete the duplicate rows from a table in SQL Server ??

Question Posted / himmat

Answer Posted / himmat

delete from table name
having count(column name)>1
group by column name

Is This Answer Correct ?

15 Yes

25 No

Please Help Members By Posting Answers For Below Questions

Explain the third normal form(3nf)?

891

Explain syntax for viewing, dropping and disabling triggers?

896

What is usually the first word in a sql query?

1068

Differentiate between a local and a global temporary table?

897

What is right outer join in sql server joins?

1115

What is the data tier application?

169

What is a partitioned view?

948

Do you know the isolation level that sql server support?

920

Can you get second highest salary from the table?

909

which backup strategy you are following at ur company

2103

How to receive output values from stored procedures?

1053

What is data source document?

976

Which autogrowth database setting is good?

999

What is the full form of ddl?

864

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

112