find out the second highest salary?
Answer Posted / prasant
SQL> select max(sal) from emp where sal<(select max(sal)
from emp);
MAX(SAL)
----------
3000
| Is This Answer Correct ? | 22 Yes | 3 No |
Post New Answer View All Answers
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
What happens to the indexes if a table is recovered?
Which environment variables are absolutely critical in order to run the OUI?
Differentiate between pre-select and pre-query?
How to delete a user account in oracle?
What are advantages of dateset in datastage?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
What is a read only transaction in oracle?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
How to check database size in Oracle?
What are the different types of trigger and explain its various uses and functions?
How do I manually create a database in oracle?
List the various oracle database objects?
What is instant client oracle?
What are the limitations oracle database 10g xe?