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 |
|
shohelic
Starting Member
6 Posts |
 Posted - 2007-01-31 : 00:51:43
|
| I'v a table tab1 without any identity colum. There are many rows. But it has some duplicate rows, which are same with each column. Look at the table:--------------------------------------id dist div thana mouza--------------------------------------1 DH DH GP SD2 DH AB GP FG2 DH AB GP FG3 CG RT TP ER4 CG RT RT YU4 CG RT RT YU4 CG RT RT YU5 RJ RP HL RR6 RJ FG HJ LK---------------------------------------I want to delete the duplicate rows accept 1. I mean I want to keep 1 row and delete the other row(s). See the hilighted rows. I want to keep 1 row from the duplicate rows.-Shohel |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
|
|
|
Another Delete Problem