Interested to Buy Any Domain ? << Click Here >> for more details...
Is it possible to delete duplicate rows in a table without
using a temporary table ?
- 12 Answers
- 25786 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / kumar
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 ? | 17 Yes | 6 No |
Post New Answer View All Answers
Mention a few common trace flags used with sql server?
How to count duplicated values in a column in ms sql server?
Detail about query optimizer?
what are different types of backups available in sql server? : Sql server database administration
what data regions are and what are the different data regions?
What is database white box testing?
How to truncate the log in sql server 2012? : sql server database administration
What do mean by xml datatype?
Tell me what do we need queues in sql service broker?
What are extended events in sql server?
What are entities and relationships?
What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?
What does set rowcount do?
How are the unique and primary key constraints different?
What are the advantages of passing name-value pairs as parameters?
