How To delete duplicate record from a particular table?
Answer Posted / 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 |
Post New Answer View All Answers
Explain rdbms?
How do I start and stop sql server?
what is the difference between a primary key and a unique key? : Sql server database administration
What are policy management terms?
Differentiate sql server reporting services vs. Crystal reports?
What is transaction server implicit?
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
What is 'write-ahead log' in sql server 2000 ?
What is meant by indexing files?
What is difference between views and stored procedures?
What are the 7 disadvantages to a manual system?
can a database be shrunk to 0 bytes, if not, why? : Sql server administration
what's the difference between delete table and truncate table commands? : Sql server database administration
What is code near application topology?
What is the full form of ddl?