Interested to Buy Any Domain ? << Click Here >> for more details...
How To delete duplicate record from a particular table?
- 12 Answers
- 25378 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 are the restrictions while creating batches in sql server?
What is policy based management (pbm)? : sql server database administration
what stored procedure can you use to display the current processes? : Sql server administration
What is order of B+tree?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
Why transaction is important?
what is the difference between a primary key and a unique key? : Sql server database administration
How to create a user to access a database in ms sql server using "create user" statements?
How to enter comments in transact-sql statements?
How many levels of sp nesting is possible?
What stored by the master? : sql server database administration
How to create stored procedures with parameters in ms sql server?
How to find the login name linked to a given user name?
What do you mean by SQL injection attack?
What is page-level compression?
