Find out the 3rd highest salary?
Answer Posted / ratnakar
select max(sal) from emp a where 3=(select count(sal) from
emp b where b.sal >=a.sal;
| Is This Answer Correct ? | 10 Yes | 10 No |
Post New Answer View All Answers
Are sql connections encrypted?
What is #table in sql?
What is aggregate function in sql?
Is sql developer case sensitive?
What are predefined functions in sql?
How you improve the performance of sql*loader? : aql loader
What is data control language?
What does the file extension accdb stand for?
Why is pl sql used?
what is sql? : Sql dba
What is a rank in sql?
Enlist the characteristics of pl/sql?
What does select * from mean in sql?
What is difference between procedure and trigger?
what are date and time data types? : Sql dba