Interested to Buy Any Domain ? << Click Here >> for more details...
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)
- 5 Answers
- 10678 Views
- Infosys, McAfee, I also Faced
- E-Mail Answers
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 is a print index?
Why use stored procedures in sql server?
What is the difference between set and select?
Explain error handling in ssis?
What are the pre-defined functions in the sql server?
What is a benefit of using an after insert trigger over using a before insert trigger?
what is a deadlock? : Sql server database administration
What is a fill factor?
What happens if time-only values are provided as date and time literals?
Tell me what is the significance of null value and why should we avoid permitting null values?
Can I work with several databases simultaneously? : sql server management studio
What are “lock” hints?
what data regions are and what are the different data regions?
How would you use user_constraints table in DB?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
