find out the second highest salary?
Answer Posted / anitha
select min(salary)
from (select distinct salary
from employee
order by salary desc)
where rownum <= 2
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to establish administrator authentication to the server?
what is the dual table in oracle?
Explain oracle instance.
What is a connect identifier?
Explain an exception and its types?
How would you best determine why your MVIEW couldnt FAST REFRESH?
What is max rowid in oracle?
What is memory advisor in Oracle?
how may join possible between (requisition with purchase order)
how the indexes are stored in the Oracle Database?
How to compare dates in oracle sql?
How to connect to the server with user account: sys?
How to open a cursor variable?
What is PL/SQL ?
How to display employee records who gets more salary than the average salary in the department?