Interested to Buy Any Domain ? << Click Here >> for more details...
Delete duplicate records in the emp table.
- 6 Answers
- 14821 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / srinivas ganamur
Delete from table t1
where t1.rowid>(select from table t2
from table t2
where t1.col_name=t2.col_name);
Srinivas Ganamur
Bangalore
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
Do ddl statements need commit?
What are the benefits of stored procedures?
What is spool?
How do you create an update query?
what is a table in a database ? : Sql dba
Why commit is not used in triggers?
What is the use of partition by in sql?
Define concurrency control. : Transact sql
What is acid property in a database?
Why partition by is used in sql?
What is the use of <> sql?
What are the different dcl commands in sql?
Is a secondary key the same as a foreign key?
How many indexes can be created on a table in sql?
Why use triggers in sql?
