how to find the second highest salary from emp table?
Answers were Sorted based on User's Feedback
Answer / winnie
select max(sal) from emp
where sal not in (select max(sal) from emp )
Is This Answer Correct ? | 1090 Yes | 131 No |
Answer / gayathri
select max(salary ) from emp table where sal<(select max
(salary)from emp table)
Is This Answer Correct ? | 754 Yes | 97 No |
Answer / gourvendra singh
Please put the below query, u will get the second highest
salary of the table :---
select sal from(select sal from
(select distinct sal from emp order by sal desc)
where rownum<=2 order by sal asc)
where rownum=1;
Is This Answer Correct ? | 488 Yes | 264 No |
Answer / nalini
Follow the following Query, You get the second highest
salary.
SQL> Select level,Max(sal) from emp
Where level=&level connect by prior sal>sal
group by level;
SQL> Enter the level No=2 (Here enter 2 manually)
Then you will get the 2nd highest salary.
If you want 3rd Highest salary, then enter level no=3.
Is This Answer Correct ? | 208 Yes | 105 No |
select max(sal) from emp where sal < (select max(sal) from
emp)
Is This Answer Correct ? | 86 Yes | 16 No |
Answer / anuj maheshwari
select sal from emp where sal=(select max(sal) from emp
where sal<(select max(sal) from emp));
Is This Answer Correct ? | 34 Yes | 5 No |
Answer / erp_guns
SELECT MAX(sal) from emp a where &n=(select COUNT(DISTINCT
(SAL)) from emp b where a.sal<=b.sal)
Is This Answer Correct ? | 39 Yes | 22 No |
Answer / shiva kumar
select max(salary) from table01
where salary <(select max salary from table01)
in mainframe env
Is This Answer Correct ? | 27 Yes | 13 No |
second method is
select sal from emp e1 where 2=(select count(distinct(sal))
from emp e2 where e1.sal<=e2.sal);
Is This Answer Correct ? | 35 Yes | 22 No |
how to return query output in html format? : Sql dba
What is mdf ldf and ndf?
How can we store rows in PL/SQL using array?
Why does sql need a server?
package specification-3 procedures package body-4 procedures how can i write for other procedure in package body
I want to execute a piece of code before calling a procedure. How to achieve it?
What are sql data types?
What is sql basics?
what is a primary key? : Sql dba
How can we make an if statement within a select statement?
In a Distributed Database System Can we execute two queries simultaneously ? Justify ?
Can function return multiple values in sql?