Delete duplicate records in the emp table.
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
What is scalar data type in pl sql?
What is delimiter in pl sql?
The in operator may be used if you know the exact value you want to return for at least one of the columns.
What is a native sql query?
How do you declare a user-defined exception?
What are the possible values for the boolean data field?
What are the two different parts of the pl/sql packages?
How do you use a while loop in pl sql?
what is the difference between cluster and non cluster index? : Sql dba
What is normalization sql?
What is an inner join sql?
how to drop an existing view in mysql? : Sql dba
Explain spool.
What is a temp table?
What is difference between sql and mysql?