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


Please Help Members By Posting Answers For Below Questions

How to speed up webrick?

815


Write a trigger example in oracle?

765


How would you go about verifying the network name that the local_listener is currently using?

1791


What is a partition in oracle?

762


How to compare dates in oracle sql?

830






How to convert times to characters in oracle?

787


How to put more than 1000 values into an oracle in clause?

761


Explain the use of indexes option in exp command.

757


What is the minimum client footprint required to connect c# to an oracle database?

758


How to define and use table alias names in oracle?

698


What is meant by joins?

814


How to revoke create session privilege from a user in oracle?

732


What is hot backup and logical backup?

787


What are the execution control statements?

801


How to insert multiple rows with one insert statement in oracle?

766