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 problem one might face while writing log information to a data-base table in pl/sql?
How to get unique records from a table?
What is exit statement?
what is a database? : Sql dba
What are the limitations of sql express?
How to make a copy values from one column to another in sql?
Is mariadb nosql?
Why we use stored procedure instead of query?
What are the 3 types of behavioral triggers?
What are schema-level triggers?
Why is the cursor important?
What is the max nvarchar size?
Is sql procedural language?
What are analytic functions in sql?
Mention what is the function that is used to transfer a pl/sql table log to a database table?