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
how to see the create table statement of an existing table? : Sql dba
What is the use of partition by in sql?
What does an inner join do?
explain commit and rollback in mysql : sql dba
Why should I use postgresql?
What's the procedure?
How does postgresql compare to "nosql"?
What is trigger explain it?
Compare sql & pl/sql
List and explain the different types of join clauses supported in ansi-standard sql?
Which column of the user triggers data dictionary view displays the database event that will fire the trigger?
what are the differences between char and nchar? : Sql dba
how to enter characters as hex numbers? : Sql dba
How do I remove all records from a table?
What does the argument [or replace] do?