How To delete duplicate record from a particular table?
Answers were Sorted based on User's Feedback
Answer / deepa
For Example
sno names
1 arun
2 arun
3 arun
6 arun
7 bala
11 bala
12 guna
9 guna
14 guna
10 raj
13 raj
Table Name T1
Fields Names Sno,Names
Delete From t1 where sno not in
(select min(sno) from t1 group by names)
| Is This Answer Correct ? | 2 Yes | 5 No |
Answer / parashu
Delete from <TableName> where <fieldName> in (select
<FieldName> from <TableName> Group By <FieldName> Having
(Count(<FieldName>)>1))
| Is This Answer Correct ? | 0 Yes | 8 No |
What are some examples of schemas?
explain the type of contraints
what are the advanced features in sql 2008?
What is change tracking in sql server?
What is the server name in sql server?
Can anybody explain me cold backup and hot backup?
Can we rewrite subqueries into simple select statements or with joins? Example?
What is the difference between a Application Server and a Database
What is the difference between the 2 operating modes of database mirroring?
Explain view in sql server?
What is meant by indexing files?
what is blocking? : Sql server database administration
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)