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
how to write date and time literals? : Sql dba
How to display the records between two range in Oracle SQL Plus?
Can we use rowid as primary key?
Explain spool.
What is server name sql?
How can I make sql query run faster?
What is the reports view in oracle sql developer?
What is a primary key example?
What are the ways on commenting in a pl/sql code?
How do you write an index?
I need a function for a train ticket reservation please answer it thanks in advance
What is cursor explain with example?
what is sql in mysql? : Sql dba
What are database links used for?
Which constraints we can use while creating database in sql?