single delete sql statement - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Old Forums

CLOSED - General SQL Server

single delete sql statement

Author

Topic

sanjnep
Posting Yak Master

191 Posts

Posted - 2005-08-02 : 15:47:22

Hi All,
Again interview question. Is it possible to remove duplicate values from a single column table using single delete statement?
For example
data
---------
1
1
2
2
2
3
4
4
4
4

I need to delete the data from the table and following data should remain on the table.
data
--------
1
2
3
4

Thanks
Have a nice time