DELETE FROM User_Details WHERE UserID=( SELECT t1.UserID FROM ( SELECT U

write a query to delete similar records in same table

Question Posted / manjula

13 Answers
24547 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

Please Help Members By Posting Answers For Below Questions

Is pl sql different from sql?

938

Define sql delete statement.

955

What is dba in sql? : SQL DBA

999

What is the difference between a subquery and a join?

1014

what are the authentication modes in sql server? How can it be changed? : Sql dba

1324

Can a table have no primary key?

1011

What is a primary key sql?

992

Why truncate is faster than delete?

1055

What are the types of subqueries?

1018

What is nosql db?

926

How do I trace sql profiler?

923

Are null values same as that of zero or a blank space?

969

What are the different types of triggers?

1057

Why is pl sql needed?

877

what is datawarehouse? : Sql dba

955