Mr. Parashu, Ur query will delete all dup rec at all. the solution should

How To delete duplicate record from a particular table?

Question Posted / sybaseexperties

Mr. Parashu, Ur query will delete all dup rec at all. the
solution should be for del dups but keepning single record.
understand?? :)

Is This Answer Correct ?

4 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Write an sql query to find first weekday of the month?

864

How to optimize stored procedure optimization?

843

Please explain go command in sql server?

991

in the physical file layout, where should the transaction log be stored in relation to the data file?

940

If user is owning any SQL Objects, can we drop that user

2008

What is wrong with sql server client libarary dll, ntwdblib.dll?

994

What is bcnf normalization form?

1065

What is log cache in sql server?

982

Write a code to select distinct records without using the DISTINCT keyword.

1049

What is difference between group by and having?

908

List the different index configurations possible for a table?

882

Will the writetext statement activate a trigger?

1000

What are the advantages of having an index on the sql server?

872

Can sql servers linked to other servers like oracle?

902

Explain what is the use of custom fields in report?

870