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

Is the log file is a part of file group?

1041

Explain syntax for disabling triggers?

1043

Define cross join in sql server joins?

1021

What are the properties of primary key?

974

What are the different types of locks in the database?

925

When does a workload on SQL Azure get throttled?

131

Mention the 3 ways to get a count of the number of records in a table.

978

What are horizontal and vertical scaling?

172

What is simple indexing method?

1032

how to invoke a trigger on demand? : Sql server database administration

1087

How many triggers are possible per table?

1098

How to delete database objects with "drop" statements in ms sql server?

1089

In what three ways is the return statement used in a stored procedure?

1008

what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

990

How will you decide the active and passive nodes?

1132