Find out the 3rd highest salary?
Answer Posted / durgashivashankar
select min(sal) from (Select rownum,sal FROM emp> Order
by sal desc)
where rownum<=3
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is trigger in sql? Explain
how is exception handling handled in mysql? : Sql dba
How do I delete a trigger?
What is the difference between inner join and outer join?
How can check sql version from command line?
What is a sql select statement?
What is duration in sql profiler trace?
Explain lock escalation? : Transact sql
How many tables can you join in sql?
How to prepare for oracle pl sql certification?
How can we make an if statement within a select statement?
What is latest version of sql?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
Can we insert delete data in view?
What is the maximum number of triggers, you can apply on a single table?