How to delete duplicate records from a table?(for suppose in
a table we have 1000 Records in that we have 200 duplicate
Records , so ,how to findout that duplicate Records , how to
delete those Records and arranged into sequence order? one
more thing that there is no primary key at all)
Answer Posted / sirisha
with numbered as(select rowno = row_number() over(partition
by empid order by empid),empname from employee)delete from
numbered where rowno > 1
Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration
How self join is different from outer join?
What stored by the model?
Differentiate sql server reporting services vs. Crystal reports?
What are the various editions of sql server 2017 that are available in the market?
What is the recovery model? List the types of recovery model available in sql server?
Can we call future method from trigger?
What do you do in data exploration
What is difference between drop truncate and delete?
How to identify current user in ssrs report?
How do you improve the performance of a SQL Azure Database?
What is database replication? What are the different types of replication you can set up in sql server?
Do you know clustered and non-clustered index?
What is nolock hint in sql server 2008
What is it unwise to create wide clustered index keys?