Solution:
Delete Top (Select Count(*)-1 From employee_test Where employeeid =6)
From employee_test
Where employeeid=6
How to Delete Duplicate Rows retaining only one of them from every set of duplicates - SQL29/1/2013 Solution: Delete Top (Select Count(*)-1 From employee_test Where employeeid =6) From employee_test Where employeeid=6
0 Comments
Leave a Reply. |
Welcome!Welcome to our edition of eblog! This section will help you find various post and articles that can help you in some of your IT work especially implementing MS BI Solutions. We hope you find this section useful. If you will need further information, please send us your questions and inquiries by going to the "Contact Us" section. Enjoy reading. [Jhon S] Categories
All
|