find out the second highest salary?
Answer Posted / hiten
select max(sal) from emp where sal not in(select max(sal)
from emp);
Is This Answer Correct ? | 25 Yes | 2 No |
Post New Answer View All Answers
How to speed up webrick?
Write a trigger example in oracle?
How would you go about verifying the network name that the local_listener is currently using?
What is a partition in oracle?
How to compare dates in oracle sql?
How to convert times to characters in oracle?
How to put more than 1000 values into an oracle in clause?
Explain the use of indexes option in exp command.
What is the minimum client footprint required to connect c# to an oracle database?
How to define and use table alias names in oracle?
What is meant by joins?
How to revoke create session privilege from a user in oracle?
What is hot backup and logical backup?
What are the execution control statements?
How to insert multiple rows with one insert statement in oracle?