Interested to Buy Any Domain ? << Click Here >> for more details...
How To delete duplicate record from a particular table?
- 12 Answers
- 24503 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 security principals used in sql server 2005?
What is transact-sql language?
in the physical file layout, where should the transaction log be stored in relation to the data file?
How to check parameter value in stored procedure sql server?
Explain about local stored procedure?
What is amo? : sql server analysis services, ssas
What happens if null values are involved in boolean operations?
what is a schema in sql server 2005? : Sql server database administration
Explain cursor as data base object?
What is difference between group by and having?
What is create statement?
What is the difference between stored procedure and user defined functions?
What is merge replication?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
What is the difference between nvl and nvl2?
