write a query to delete similar records in same table
- 13 Answers
- 22806 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / manjula
DELETE FROM User_Details WHERE UserID=(
SELECT t1.UserID FROM
( SELECT UserID, count(*) AS Counts FROM User_Details GROUP
BY UserID HAVING count(*) > 1 )AS t1
)
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?
How can we solve sql error: ora-00904: invalid identifier?
Is sqlexception checked or unchecked?
How do I view a view in sql?
How to revise and re-run the last sql command?
Is sql scripting language?
What is sql prepared statement?
how many triggers are allowed in mysql table? : Sql dba
Why coalesce is used in sql?
what are the advantages of mysql in comparison to oracle? : Sql dba
What is the difference between view and stored procedure?
Write a sql select query that only returns each name only once from a table?
What is a pl/sql block?
what are the properties and different types of sub-queries? : Sql dba
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
