write a query to delete similar records in same table
Answer Posted / kirankumar.vangeti
delete from emp
where rowid not in (select max(rowid)
from emp
group by emp_number);
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Why are indexes and views important to an organization?
What is a trigger word?
Is sql a backend?
What do you mean by “trigger” in sql?
Is sql better than excel?
What is the difference between in and between in sql?
Does a user_objects view have an entry for a trigger?
What is the difference between sql, mysql and sql server?
Explain the significance of the & and && operators in pl sql.
What is sql character function?
Why truncate is used in sql?
What is the difference between sum and count in sql?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
What is the difference between an inner join and an outer join?
What packages are available to pl/sql developers?