Find out the 3rd highest salary?
Answer Posted / arindam
select min(sal) from
(
select sal from
(
select distinct sal from emp order by sal desc
)
where rownum<=3
)
where rownum <4
| Is This Answer Correct ? | 5 Yes | 7 No |
Post New Answer View All Answers
What is sql clause?
how to run 'mysql' commands from a batch file? : Sql dba
Explain what is a subquery ?
How to load data with sql*loader?
What will you get by the cursor attribute sql%found?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
What are the key differences between SQL and PL SQL?
What is the difference among union, minus and intersect?
What is difference between left and right outer join?
What is procedure in pl sql?
what are the advantages a stored procedure? : Sql dba
What is materialized view in sql?
What is %rowtype in pl sql?
What is pl sql variable?
What is dba in sql? : SQL DBA