Write a query to delete duplicate records in SQL SERVER
- 36 Answers
- 67534 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / vijay
WITH INTER_TABLE(ROW, COL1) AS(
select row_number() over (partition by
COL1 order by COL1) as ROW ,COL1 from [TABLE_NAME]
)
Delete from INTER_TABLE where ROW > 1
| Is This Answer Correct ? | 22 Yes | 4 No |
Post New Answer View All Answers
Difference between report and query parameter. Why do we need different type of parameter?
What is the xml datatype?
How to find out the list schema name and table name for the database?
If user is owning any SQL Objects, can we drop that user
What are group functions in query statements in ms sql server?
Where do you find the default Index fill factor and how to change it?
Why and when do stored procedure recompile?
What are cursors and when they are useful?
What are Row versions of DataRow?
What does set rowcount do?
What is the sql server agent?
What is the difference between function and stored procedure in sql server?
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
How many primary keys are possible in a table?
What are the lambda triggers?
