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
How do I know if oracle client is installed on windows?
How to call a stored function with parameters?
What is key preserved table?
Can you create a synonym without having a table?
What is bulk collect in oracle?
Explain the use of record option in exp command.
How to create an oracle database manually?
Give the advantages and disadvantages of clusters.
How to return top 5 rows in oracle?
How do I know if oracle is installed on windows?
How to pass parameters to procedures in oracle?
What to do if the startbd.bat failed to start the xe instance?
How would you change old and new values in an insert, delete and update triggers?
how to make an oracle object
What privilege is needed for a user to create tables in oracle?