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
Can we protect our pl/sql source code?
what is dynamic SGA and static SGA
How to define a sub function?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
How to save query output to a local file?
How to convert characters to times in oracle?
What are the execution control statements?
Why is oracle so popular?
How to store pictures on to the database?
Describe an oracle table?
How can we find out the current date and time in oracle?
What happens to the current transaction if the session is ended?
Why do you use stored procedures and state some of its disadvantages?
Is primary key indexed by default in oracle?
Explain enable novalidate constraint.