Answer Posted / lova raju allumalla
delete from emp where rowid not in (select min(rowid) from
emp group by empno);
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
Why functions are used in sql?
How to revise and re-run the last sql command?
Explain commit, rollback and savepoint.
Can a select statement fire a trigger?
Why self join is used in sql?
What are the different operators available in sql?
How do I delete a trigger?
How does postgresql compare to "nosql"?
What is difference between left and right outer join?
what is “go” in t-sql? : Transact sql
What are actual parameters and formal parameters?
What is constant in pl sql?
Name three sql operations that perform a sort.
How many subqueries can be nested in a statement?
What is a record in a database?