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
Explain the rollback statement?
what is a relationship and what are they? : Sql dba
What is date functions?
Can we use insert statement in function?
Why is there a need for sqlcode and sqlerrm variables?
What do you understand by case manipulation functions?
How many types of sql are there?
Which is better cte or subquery?
Can we connect to postgresql using sql developer?
Explain the purpose of %type and %rowtype data types?
What is sql server and ase?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
What is partition in sql query?
What is a memo field?
how can you see all indexes defined for a table? : Sql dba