how to check the 3rd max salary from an employee table?
Answers were Sorted based on User's Feedback
Answer / manish_patil
select sal from emp_sal where rownum = 3 order by sal desc
Is This Answer Correct ? | 6 Yes | 9 No |
Answer / tushar
select max(sal) from ( select sal from emp group by sal order by sal) where rownum<4;
Is This Answer Correct ? | 0 Yes | 3 No |
Answer / nagendra
select min(sal) from emp where sal in( select top 3 sal
from emp order by sal desc)
Is This Answer Correct ? | 2 Yes | 6 No |
How do I install sql?
Which sql most popular?
Explain the difference between drop and truncate commands in sql?
What are analytical functions in sql?
What is differance unique key and primary key.
Can we insert in sql function?
Explain how to use transactions efficiently : transact sql
Explain foreign key in sql?
Why use stored procedures?
Is sql a backend language?
What is difference between sql function and stored procedure?
what are the advantages a stored procedure? : Sql dba