delete id from table where id in(select id from table having count(id)>1

Delete duplicate records from the table?(Table must have
unique id)

Question Posted / naren

Answer Posted / naren

delete id from table where id in(select id from table having count(id)>1)

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How do you clear a log file?

1110

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

1060

what is the system function to get the current user's user id? : Sql server database administration

1071

What are the different types of columns types constraints in the sql server?

1132

How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

1248

What is the data type of time?

1017

Write a sql query to display the current date?

1145

What is the maximum size of sql server database?

1063

How to use column default values in insert statements in ms sql server?

1102

What do you do in data exploration

1050

What is difference between primary key and foreign key?

952

Which is faster statement or preparedstatement?

1003

What do you mean by subquery?

1149

What is the purpose of the model database?

1067

What are the difference between clustered and a non-clustered index?

1090