write a query to delete similar records in same table
Answer Posted / balaji
delete from sampletable where ids in(select ids from
sampletable group by ids having count(ids)>1)
Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
How do you optimize a stored procedure query?
How can use stored procedures in sql?
Explain the select statement in sql?
what are null values? : Sql dba
What is the maximum number of triggers, you can apply on a single table?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
What is aggregate function in sql?
explain mysql aggregate functions. : Sql dba
What is a primary key sql?
Explain architecture of sql server notification services?
What are the ddl commands?
How does index help in query performance?
Which join is default?
What is substitution variable?
How to use sql statements in pl/sql?