How To delete duplicate record from a particular table?
- 12 Answers
- 22867 Views
- eXensys, Foxfire, I also Faced
- E-Mail Answers
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
Name the different type of indexes in sql?
What is exporting and importing utility?
What is user-defined functions? What are the types of user-defined functions that can be created?
What new data source types were added in ssrs 2014?
How do I create a stored procedure in dbml?
Explain about the command-line tool SQLCMD?
Explain different types of lock modes in sql server 2000?
What are different types of table joins?
What happens if we shrink log file in sql server?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
Which tcp/ip port does the sql server run on? How can it be changed?
What are the differences between stored procedure and the dynamic sql?
What do you mean by cardinality?
What is an execution plan? How would you view the execution plan?
Which is the latest version of sql server and when it is released?
