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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-15 : 08:31:51
|
| Nikhil writes "HiI have a table as TEST_TABLE and it has only a single column in it by the name COLUMN. This table has some indexes and references on it so that it cannot be deleted.Now I fired following insert statements:INSERT TABLE VALUES(1)INSERT TABLE VALUES(2)INSERT TABLE VALUES(3)INSERT TABLE VALUES(4)INSERT TABLE VALUES(2)INSERT TABLE VALUES(2) I want to delete duplicate records from the table. How can I delete them without using a cursor or even a trigger for that matter.Any help would be appreciated and acknowledgedRegards" |
|
|
|
|
|
Deleting Duplicate records in a table having a single column