Find out the 3rd highest salary?
Answer Posted / shaiju nair
select min(sal) from (Select sal
FROM emp where rownum<=3
Order by sal desc)
Is This Answer Correct ? | 13 Yes | 25 No |
Post New Answer View All Answers
What do you understand by pl/sql records?
When is the update_statistics command used?
What are reports usually used for?
How many aggregate functions are available there in sql?
Define commit, rollback and savepoint?
What is tuple in sql?
What is composite data type in pl sql?
Does sql view stored data?
What is sql engine in oracle?
What is sharding in sql?
What is cold data?
what are the t string functions available in tsql? : Transact sql
What is the difference between null value, zero, and blank space?
what is rdbms? : Sql dba
What are the two different parts of the pl/sql packages?