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
How to replace given values with null using nullif()?
how many clustered indexes can be created on a table? : Sql server database administration
What is the server name for sql management studio?
what is an extended stored procedure? : Sql server database administration
What are synonyms?
Can we use where and having clause together?
What is lock escalation and what is its purpose?
what is the information that can be stored inside a bit column? : Sql server database administration
Explain left outer join and right outer join?
How to return the second 5 rows in ms sql server?
What are the advantages of using third-party tools?
Can a table have 2 primary keys?
What is ms sql server service broker?
What is a partition function in sql server?
Explain how would you store your query in an SSRS report or a Database server?