find out the third highest salary?
Answer Posted / amrish singh
this is the query for retrieving nth highest salary from
table emp
select e.sal
from emp e
where n-1=(select count(*) from emp s where s.sal>e.sal)
putting the value of n we get the required result.
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
What is rowid and rownum in oracle?
Can we protect our pl/sql source code?
How to create an oracle testing table?
How do you tell what your machine name is and what is its IP address?
What is bulk load in oracle?
What is BBED in Oracle?
Explain the use of control file?
What is not equal to in oracle?
Can we save images in a database and if yes, how?
Can multiple columns be used in group by in oracle?
How to call a sub procedure?
How to use windows user to connect to the server?
What are the differences between interval year to month and interval day to second?
Difference between cartesian join and cross join?