Interested to Buy Any Domain ? << Click Here >> for more details...
How To delete duplicate record from a particular table?
- 12 Answers
- 24907 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 should be the fill factor for indexes created on tables? : sql server database administration
Where cross join is used?
What are the transaction properties?
When we should use and scope of @@identity?
What is query parameter in ssrs?
Write an SQL query to obtain the 2nd highest salary.
How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?
In what three ways is the return statement used in a stored procedure?
can you implement data mining in SSRS?
What is the main difference between ‘between’ and ‘in’ condition operators?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
Differentiate between delete and truncate.
What is the sql server 2000 version number?
what are the different types of replication you can set up in sql server? : Sql server database administration
Can you roll back the ddl statement in a trigger?
