SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Another Delete Problem
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

shohelic
Starting Member

6 Posts

Posted - 01/31/2007 :  00:51:43  Show Profile  Reply with Quote
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

khtan
In (Som, Ni, Yak)

Singapore
17681 Posts

Posted - 01/31/2007 :  01:05:37  Show Profile  Reply with Quote
see http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6256


KH

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000