find the third highest salary?

Answers were Sorted based on User's Feedback



find the third highest salary?..

Answer / justin

SELECT sal FROM empORDER BY sal DESC LIMIT 2 , 1

Is This Answer Correct ?    0 Yes 2 No

find the third highest salary?..

Answer / purushotham

select level,max(sal)
from table
where level=3
connect by prior sal>sal
group by level

Is This Answer Correct ?    0 Yes 6 No

find the third highest salary?..

Answer / mousumi dalai

select min(sal) from emp where sal in
(select sal from emp order by sal desc where ROWCOUNT <=3) ;

Is This Answer Correct ?    9 Yes 36 No

Post New Answer

More SQL PLSQL Interview Questions

How to process query result in pl/sql?

0 Answers  


How many types of tables are there?

0 Answers  


What is nosql vs sql?

0 Answers  


Explain ttitle and btitle.

0 Answers  


What is Referential Integrity?

3 Answers  






package specification-3 procedures package body-2 procedures will is execute

2 Answers   PWC,


what is sql profiler

2 Answers   Fidelity,


How do I remove sql developer from windows 10?

0 Answers  


Why do we use procedures in sql?

0 Answers  


Why we use stored procedure instead of query?

0 Answers  


What is the difference between drop and truncate commands?

0 Answers  


how to sort records in sql?

3 Answers  


Categories