How to Remove the 3rd highest salary person record from
table?
Answer Posted / manoj
delete from employee where sal = (select sal from (select sal from employee order by sal desc) where rownum = 3);
Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
How many file formats are supported to export data?
Query to retrieve record for a many to many relationship ?
What is the difference between truncate & delete command?
What is raw datatype in oracle?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
Explain what are the type of synonyms?
How to define an anonymous block?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
How to store pictures on to the database?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
Is oracle an open source?
types of indexes and the rationale behind choosing a particular index for a situation.
What are the set operators union, union all, minus & intersect meant to do?
State the various uses of dbcc command?
What is oracle rownum?