how to delete duplicate rows - 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

SQL Server 2000 Forums

SQL Server Development (2000)

how to delete duplicate rows

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-07-15 : 10:32:02

Sanjay Banik writes "i've three duplicate rows and i've to delete only two rows, how can i do this thing in SQL SERVER without using any cursor, temporary tables or by using any table variables.

for e.g.

Table Name : myTable
Field Name : A || B
============================
Row1 : A1 B1
Row2 : A1 B1
Row3 : A1 B1

Output will be :

Table Name : myTable
Field Name : A || B
============================
Row1 : A1 B1"

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2004-07-15 : 10:32:02

We've got an article written on deleting duplicates. I think it will answer your problems. Search on "deleting duplicates".

vsrajan76
Starting Member

10 Posts

Posted - 2004-07-15 : 10:44:25

check this link...

http://www.tkdinesh.com/faq/ans/duplicate.html

Hope this helps!!!

-sundar

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2004-07-15 : 13:02:50

And how about the link to the article on THIS site: http://www.sqlteam.com/item.asp?ItemID=3331

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources