Is it possible to delete duplicate rows in a table without
using a temporary table ?
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
what are the critical issues you have resloved in your company
What type of Index will get created after executing the above statement?
What is the contrast amongst drop and truncate?
How to insert stored procedure result into temporary table?
What is cte (common table expression)?
How to recreate an existing index in ms sql server?
Write a code to select distinct records without using the DISTINCT keyword.
What are the steps to process a single select statement?
What are the properties of sub-query?
Can a table be moved to different filegroup?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
How to find table changes in sql server?
What is transact-sql language?
What is the purpose of update statistics and scope_identity() function?