Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to delete similar records in same table
- 13 Answers
- 25119 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 foreign key? : Sql dba
How do you declare a variable in pl sql?
Explain the methods used to protect source code of pl/sql.
what is myisam? : Sql dba
What is the mutating table and constraining table?
What are types of joins?
How to run sql statements through the web interface?
What is compilation error in pl sql?
Which are sql * plus commands?
Which join is like inner join?
What is the difference between a procedure and a function?
What is the difference between local and global temporary table?
Explain the types of joins in sql?
What is the difference between nvl function, ifnull function, and isnull function?
What is the requirement of self-join?
