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
Name the operator which is used in the query for pattern matching?
What are the three forms of normalization?
What plvcmt and plvrb does in pl/sql?
Can you do multiple joins in sql?
What is left inner join in sql?
what is 'mysqlshow'? : Sql dba
What is trigger in flip flop?
Does sql support programming?
Is a table valued function object?
What is date functions?
How do I enable sql encryption?
Can instead of triggers be used to fire once for each statement on a view?
What is offset in sql query?
What are the different dcl commands in sql?
Why do we use cursors?