find out the third highest salary?
Answer Posted / vanaja
select * from emp5 where salary in(select min(salary) from
emp5 where salary in(select top 3 salary from emp5 order by
salary desc))
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is a directory object?
Differentiate between function and procedure in oracle.
What are the limitations oracle database 10g xe?
State any two functions of oracle?
How to login to the server without an instance?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
What is oracle rownum?
Can we write insert statement in function in oracle?
Is oracle a programming language?
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'));
interview questions with answer for cts
What is the Tune Query
What is using clause and give example?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
Does facebook use oracle?