Delete Duplicated Rows in SQL Server

[vinay.sindri]

Hi!How can we delete duplicated rows of a table in SQL Server.

[jhecht]

DELETE FROM table WHERE table_id_column NOT IN (select distinct table_id_column from table) Tried that?

[vinay.sindri]

DELETE FROM table WHERE table_id_column NOT IN (select distinct table_id_column from table) Tried that?

What if no id column is there?

[Synook]

Good database design practice: always have index columns for tables (i.e. all of them except ones purely for relational purposes).But, if it is too late to insert an index then you will have to combine columns in an attempt to eliminate accidental deletions... umm... better to just define an index column lol

[jhecht]

Good database design practice: always have index columns for tables (i.e. all of them except ones purely for relational purposes).But, if it is too late to insert an index then you will have to combine columns in an attempt to eliminate accidental deletions... umm... better to just define an index column lol

Yes, if it is a direct-access table, please, always use an ID. It makes it easier on you later.DELETE FROM table WHERE table_title_column NOT IN (select distinct table_title_column from table)