How to delete duplicate record in sql serer
plz suggest me............

thanks

Recommended Answers

Hard to suggest without more information about your table structure and data.

Jump to Post

the following link will be helpful when your table has no key for any any column

http://www.codeproject.com/Tips/159881/How-to-remove-duplicate-rows-in-SQL-Server-2008-wh

as pritaeas said

its very difficult to give the answer for your requirement without knowing the …

Jump to Post

All 9 Replies

Hard to suggest without more information about your table structure and data.

the following link will be helpful when your table has no key for any any column

http://www.codeproject.com/Tips/159881/How-to-remove-duplicate-rows-in-SQL-Server-2008-wh

as pritaeas said

its very difficult to give the answer for your requirement without knowing the structure of the table

please provide the table stucture once so that we are here to help you

happy coding

Sorry for waiting..........

Table 1
id  name    city
 1  john    abc
 2  raj      ab

Table 2
id  name    dob
2   raj     ab
3   Mathu   abc

this is the table structure

I am waiting for your response ...........

hai pssingh1001,

please be more informative in your requirement (i.e what do you want and what do you have so far)

explain briefly so that we will help you

I am extremely sorry   .......All.
I was going to wrong side...
this is the table structure ,the Id field 2 is repeted twice .
   Table 1
    id  name city
    1  john  abc
    2  raj   ab
    2  raj   ab
    3  Mathu abc


    then how to delete its duplicacy....
    plz suggest....

hai pssingh1001,

have you gone through the URL which i have posted initially?( see top most one)

thats help you a lot for this kind of requirement

please check its one and let me know the status

happy coding

Hi All.......................
thanks the above mentioned kinks are suitable for me///
If do u have other links , I will prefer.............

Thanks for sharing yr view...........

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.