Write a query to delete duplicate records in SQL SERVER
Answer Posted / kalyan
with [TN ordered by CN] as
(
select row_number() over(partition by CN order by CN) as
rowid,* from TN
)
delete from [TN ordered by CN] where rowid > 1
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How can you tell if a database object is invalid?
Do you know concepts and capabilities of sql server?
What is simple indexing method?
How to create a simple table to test triggers in ms sql server?
what is the system function to get current user's user id? : Sql server database administration
Where do you find the default Index fill factor and how to change it?
What is molap and its advantage? : sql server analysis services, ssas
What is normalization? Explain different forms of normalization?
Explain the Ways to improve the performance of a sql azure database?
Why use stored procedures in sql server?
What is federation member?
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
Can foreign key be deleted?
What is the use of tempdb? What values does it hold?
What is the current limitation of the size of SQL Azure DB?