Interested to Buy Any Domain ? << Click Here >> for more details...
How To delete duplicate record from a particular table?
- 12 Answers
- 25379 Views
- eXensys, Foxfire, I also Faced
- E-Mail Answers
Answer Posted / srinivasan
WITH CTE AS
(
SELECT * ,ROW_NUMBER() OVER (PARTITION BY ID,NAME
ORDER BY ID DESC) AS RNUM FROM TABLE A
)
DELETE CTE WHERE RNUM >1
IF U HAVE ANY MORE DOUBTS
MAIL ME MCAVASAN@GMAIL.COM
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
What is a print index?
What is the data tier application?
Can you explain various data region available in ssrs with their use?
Detail about query optimizer?
In which format does an image save in SQL Server database ?
What is use of dbcc commands?
What is the New in SQL server 2008?
how you can move data or databases between servers and databases in sql server? : Sql server administration
Where sql server user names and passwords are stored in sql server? : sql server database administration
What objects does the fn_my_permissions function reports on? : sql server security
Why use stored procedures in sql server?
What are translations and its use? : sql server analysis services, ssas
How much memory that we are using in Logshipping Concept?
Explain multiserver query
