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
25158 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

Which certification is best for sql?

993

What is the maximum number of triggers, you can apply on a single table?

1001

What are pl/sql packages?

1107

Is sql free?

975

What are the different ways to optimize a sql query?

951

Can we use commit inside a trigger?

1098

What are the built in functions of sql?

1031

What are the parts of a basic sql query?

977

Explain what is a subquery ?

1193

What is sql and db2?

1013

What is difference between joins and union?

1133

How do you declare a constant?

965

What is the most common sql injection tool?

1047

Can I create table without primary key?

1004

What is sqlcommand?

1032