how to delete duplicate rows from table in sql server
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / swapna
We can delete duplicate rows from table by using distinct
command.
| Is This Answer Correct ? | 10 Yes | 35 No |
What is a collation?
How do you read transaction logs
What is the purpose of linked server configuration in sql server?
What is the datatype returned by count(*)
22 Answers 247Customer, Asian CERC,
How network traffic be reduced by using the stored procedure?
What is after dml trigger?
Explain how many normalization forms?
How to find the login name linked to a given user name?
What is in place upgrade in sql server?
How do I view a stored procedure in sql server query?
Alternative way to DetDate() function?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)