Interested to Buy Any Domain ? << Click Here >> for more details...
How To delete duplicate record from a particular table?
- 12 Answers
- 25367 Views
- eXensys, Foxfire, I also Faced
- E-Mail Answers
Answer Posted / sudhagar
Delete from (select * from <TABLE_NAME> where rowid not in
(select min(rowid) from <TABLE_NAME> group by c1,c2...))
| Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
What are joins in sql and what are the different types of joins?
What are the restrictions applicable while creating views? : SQL Server Architecture
What is the sql server 2000 version number?
How to start sql server browser service?
How many types of functions are there in sql server?
How to integrate the ssrs reports in application?
How to create stored procedures with parameters in ms sql server?
System variable and temporary variables
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
Define inner join in sql server joins?
What is a partitioned view?
List some case manipulation functions in sql?
What is the meaning of sql server?
How to encrypt Strored Procedure in SQL SERVER?
What are sub reports and how to create them?
