How to delete the duplicate rows from a table in SQL Server ??
Answer Posted / himmat
delete from table name
having count(column name)>1
group by column name
| Is This Answer Correct ? | 15 Yes | 25 No |
Post New Answer View All Answers
what are the different types of replication you can set up in sql server? : Sql server database administration
What is difference between group by and having?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
You want to implement the one-to-one relationship while designing tables. How would you do it?
what is a transaction and what are acid properties? : Sql server database administration
What are the two authentication modes in sql server?
What do you think of this implementation? Can this be implemented better?
What is efficiency data?
What is nolock?
How do I uninstall sql server 2014?
How do I view a script in sql server?
How to see existing views in ms sql server?
Explain index in sql server?
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
What are the reporting services components?