Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to delete similar records in same table
- 13 Answers
- 24667 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 oracle and pl sql?
How show all rows in sql?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Explain the select statement in sql?
what are the differences between require and include, include_once and require_once? : Sql dba
Can a foreign key be null?
What is cursor explain with example?
What is a join?
What is java sql drivermanager?
What is a delimiter in sas?
What is %s in sql?
What are the types of optimization?
What is the difference between database trigger and stored procedure?
What does bitemporal mean?
What do you understand by pl/sql packages?
