Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to delete similar records in same table
- 13 Answers
- 24939 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 difference between nested table and varray?
What is sql dialect?
What are the differences between implicit and explicit cursors?
What are analytical functions in sql?
What is difference between sql and mysql?
What is package in pl sql?
Why procedure is used in sql?
What is the difference between left outer join and left join?
What is dml statement?
Can we use loop in sql?
What is trigger price?
Which command is used to delete a package?
What is difference between ms sql and mysql?
Can cursors be part of a trigger body?
What is full join?
