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 is the default port for SQL Server over a firewall?
How do we know if any query is retrieving a large amount of data or very little data?
How do I edit a procedure in sql server?
Which is better statement or preparedstatement?
List out the differences between the clustered index and non-clustered index in sql server?
Can I work with several databases simultaneously? : sql server management studio
What are trace files?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
How to get a list of columns in a view using the "sp_help" stored procedure?
Describe and explain about SQL native client?
What are ddl (data definition language) statements for tables in ms sql server?
What do you understand by check constraint in sql server?
Is the primary key column of a table an index in ms sql server?
How to backup encryption key ?
What is an entity-relationship diagram (erd)?