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
Mention what does plv msg allows you to do?
What is type and rowtype in pl sql?
How do you rank data in sql?
What is the difference between an inner and outer join?
What is rank () in sql?
how to check server status with 'mysqladmin'? : Sql dba
what is transaction? : Sql dba
What is time based sql injection?
What is the difference between distinct and unique in sql?
What is your daily office routine?
how is myisam table stored? : Sql dba
How do rank () and dense_rank () differ?
What is the use of count (*) in sql?
Explain autonomous transaction.
how to get a list of indexes of an existing table? : Sql dba