Is it possible to delete duplicate rows in a table without
using a temporary table ?
- 12 Answers
- 21738 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / krishnaraj p n
Can be done in a simple way.
DELETE FROM <TABLE NAME > WHERE <COLUMN NAME >IN
(
SELECT <COLUMN NAME> FROM <TABLE NAME >
GROUP BY <COLUMN NAME>
HAVING COUNT(<COLUMN NAME>) > 1
)
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
What is 'Join' and explain its various types.
What the class forname () does?
What are the pre-defined functions in the sql server?
Explain iaas, paas and saas?
What is temporal table?
Explain tablesample?
What is unpivot?
Explain user defined functions?
What is the order in which the sql query is executed?
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
Can you explain different types of locks in sql server?
How to use subqueries with the exists operators in ms sql server?
Can you explain what is the use of custom fields in report?
what are the different types of replication you can set up in sql server? : Sql server database administration
