How To delete duplicate record from a particular table?
Answer 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 |
Post New Answer View All Answers
What are the properties of primary key?
How to create a scrollable cursor with the scroll option?
What are the disadvantages of using querystrings to send data from one page to another?
Explain the flow of creating a cube? : sql server analysis services, ssas
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
What is set nocount on and what is set nocount off?
In case you have filters in your report, when filters will be applied in cached report instance?
How many servers can we create in a single subscription?
User wants only to display only pdf as export option in report manager. How to achieve this?
Can we write trigger for view?
What is data set in report?
How do I edit a procedure in sql server?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
How do I view a trc file?
As per your opinion what are the five top responsibilities of a dba? : sql server database administration