find out the third highest salary?
Answer Posted / harikrishna ravipati
select max(sal) from emp where sal <
(select max(sal) from emp where sal <
(select max(sal) from emp))
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to define an anonymous procedure without variables?
What is the difference between formal parameters and actual parameters?
Difference between hot backup vs. Cold backup?
How many data types are supported?
What are the differences between interval year to month and interval day to second?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
How to connect to the server with user account: sys?
candidate key is subset of super key but not vice-verse explain
What is the difference between Delete, Truncate and Drop in Oracle?
What happens if you set the sga too low in oracle?
What is recovery manager in Oracle?
What is the difference between truncate & delete command?
How to define default values for formal parameters?
What is the max number of columns in an oracle table?
How can windows applications connect to oracle servers?