find out the third highest salary?
Answer Posted / ashutosh pandey
select sal from emp
where sal=(select min(sal) from emp
where sal>(select min(sal) from emp
where sal>(select min(sal) from emp);
| Is This Answer Correct ? | 69 Yes | 204 No |
Post New Answer View All Answers
How to open a cursor variable?
How to count duplicated values in a column in oracle?
What are the execution control statements?
What is oracle server autotrace in oracle?
How do I reset a sequence in oracle?
Explain what are the advantages of views?
What is the meaning of recursive hints in oracle?
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
How to handle a single quote in oracle sql?
How to install oracle odbc drivers?
What is BBED in Oracle?
What is the exact use of Collections?
How to find the duplicate rows count from employees table in oracle?
What is the use of aggregate functions in oracle?