find out the second highest salary?

Answer Posted / premsagar12

select max(sal) from emp where sal<(select max(sal) from emp);

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I know if oracle client is installed on windows?

502


How to call a stored function with parameters?

567


What is key preserved table?

570


Can you create a synonym without having a table?

559


What is bulk collect in oracle?

560






Explain the use of record option in exp command.

543


How to create an oracle database manually?

576


Give the advantages and disadvantages of clusters.

581


How to return top 5 rows in oracle?

550


How do I know if oracle is installed on windows?

492


How to pass parameters to procedures in oracle?

572


What to do if the startbd.bat failed to start the xe instance?

613


How would you change old and new values in an insert, delete and update triggers?

545


how to make an oracle object

1862


What privilege is needed for a user to create tables in oracle?

554