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
Explain how dts is used to extract, transform and consolidate data?
What are the operating modes in which database mirroring runs?
what types of replication are supported in sql server? : Sql server database administration
Can you please differentiate between a primary key and a unique key?
what are the critical issues you have resloved in your company
Why do you need a sql server?
Explain how to maintain a fill factor in existing indexes?
Why use cursor in sql server?
Explain what are partitioned views and distributed partitioned views?
How to compare the top two records using sql?
How to write character string constants or literals in ms sql server?
What is the difference between executequery () and executeupdate ()?
What is sql language?
How to link tables in sql server?
What is ddl command?