|
shohelic
Starting Member
6 Posts |
 Posted - 01/31/2007 : 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 SD
2 DH AB GP FG
2 DH AB GP FG
3 CG RT TP ER
4 CG RT RT YU
4 CG RT RT YU
4 CG RT RT YU
5 RJ RP HL RR
6 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 |
|
Another Delete Problem
