write a query to delete similar records in same table
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 sql resultset?
Can we use the cursor's to create the collection in PL/SQL?
Explain the the update statement in sql?
What are all ddl commands?
how to escape special characters in sql statements? : Sql dba
How do you run a query?
what is subquery? : Sql dba
What is rank dense_rank and partition in sql?
Can there be 2 primary keys in a table?
How do you use collections in procedure to return the resultset?
Is keyword pl sql?
What are reports usually used for?
what are the advantages a stored procedure? : Sql dba
What is sql performance tuning?
What is an exception in PL/SQL? What are the two types of exceptions?