Interested to Buy Any Domain ? << Click Here >> for more details...
How To delete duplicate record from a particular table?
- 12 Answers
- 24932 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
What is the difference between char and varchar2 datatype in sql?
Why do we use non clustered index?
How to delete multiple rows with one delete statement in ms sql server?
Do you know what is a linked server in sql server?
What is the cpu pressure?
How can you start sql server in different modes?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
Mention the uses of stored procedures.
What is the difference between delete and truncate statements?
What is the purpose of the tempdb database?
Delete duplicate rows without using rowid.
What are 3 ways to get a count of the number of records in a table?
What do you mean by sql server agent?
Explain timestamp datatype?
What is sql server used for?
