find the third highest salary?
Answers were Sorted based on User's Feedback
Answer / justin
SELECT sal FROM empORDER BY sal DESC LIMIT 2 , 1
Is This Answer Correct ? | 0 Yes | 2 No |
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 |
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 |
How to process query result in pl/sql?
How many types of tables are there?
What is nosql vs sql?
Explain ttitle and btitle.
What is Referential Integrity?
package specification-3 procedures package body-2 procedures will is execute
what is sql profiler
How do I remove sql developer from windows 10?
Why do we use procedures in sql?
Why we use stored procedure instead of query?
What is the difference between drop and truncate commands?
how to sort records in sql?