how to delete duplicate rows from table in sql server
Answer Posted / suresh s
delete tblname where columname in (select columnname
FROM tblname GROUP BY columnname having count(columnname)
>=2)
| Is This Answer Correct ? | 25 Yes | 30 No |
Post New Answer View All Answers
What are the advantages of stored procedure in sql server?
Can sql servers link to other servers like oracle?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
How do you test your database? : sql server database administration
Explain atomicity?
What is the exact numeric data type in sql?
Do you have any idea about the tcl commands?
What do you understand by sql server agent?
How do I start sql server 2017?
What is the use of @@spid?
What is a data source or ds? : sql server analysis services, ssas
What are the restrictions while creating batches in sql server?
What are the different types of replication you can set up in sql server?
What kind of problems occurs if we do not implement proper locking strategy?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration