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 create an index on a view?
What is implicit mode in sql server?
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
Can we install sql server 2016 on windows 7?
How to create function with parameter in sql server?
What does REVERT do in SQL Server 2005?
What is sql server query analyzer?
what authentication modes does sql server support? : Sql server database administration
What is de-normalization and what are some of the examples of it?
What is the maximum size of a dimension? : sql server analysis services, ssas
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
How to override dml statements with triggers?
What is database replication?
What is the osql utility?
Is INSTEAD OF trigger directly applicable to Table ?