Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete duplicate rows in sql server2005
- 7 Answers
- 13239 Views
- Cisco, CTS, HCL, IBM, I also Faced
- E-Mail Answers
Answer Posted / surendra pal singh
delete from tablename where empname in (select empname from table name group by empname having empid>1)
where empname and empid are the columns of the table.
definately it will work
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Does sql server use java?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
what are the core components of SSRS?
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
What are the drawbacks of reporting in ssrs?
What is log in sql server?
How do I completely remove sql server instance?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What is difference between primary key and foreign key?
Why I am getting this error when renaming a database in ms sql server?
How do I find the size of a sql server database?
How to disable triggers using "disable trigger"?
What is the maximum size of column in sql server?
What is difference between clustered and non clustered index?
How to update muliple row in single query?
