Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to delete similar records in same table
- 13 Answers
- 25449 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 replication id?
What is the difference between clustered and non-clustered indexes?
How many sql databases can you have on one server?
What is meant by user defined function?
What do you mean by query optimization?
Write a unique difference between a function and a stored procedure.
What is pl sql and why it is used for?
How do I find duplicates in sql?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
Is sql scripting language?
How do I partition in sql?
What is a temporal data type?
What is the process of copying data from table a to table b?
What does the acronym acid stand for in database management?
What are three advantages to using sql?
