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
How to execute a stored procedure?
Why coalesce is used in sql?
what is the functionality of the function htmlentities? : Sql dba
What is recursive stored procedure?
What is a nested table in word?
What is the difference between delete and truncate statement in sql?
How do I run a sql query?
How do I run a query in pl sql developer?
What does data normalization mean?
What is posting?
What is varray in pl sql?
What is implicit cursor in pl sql?
Explain ddl statements in pl/sql?
how many ways we can we find the current date using mysql? : Sql dba
Which is faster view or stored procedure?