Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to delete duplicate records in SQL SERVER
- 36 Answers
- 76365 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
What are triggers? How do you invoke a trigger on demand?
What do you mean by normalisation?
What is difference between views and stored procedures?
How to override dml statements with triggers?
What is the difference between cartesian product and cross join?
What is the maximum size of sql server database?
What is a full text index?
Write an sql query for deleting duplicate rows?
How do I port a number to sql server?
What is an indexing technique?
Can you explain different types of locks in sql server?
How to identify current user in ssrs report?
How much space does sql server 2016 take?
How do I uninstall sql server 2014?
What is query processing?
