how to find the second highest salary from emp table?

Answers were Sorted based on User's Feedback



how to find the second highest salary from emp table?..

Answer / winnie

select max(sal) from emp
where sal not in (select max(sal) from emp )

Is This Answer Correct ?    1090 Yes 131 No

how to find the second highest salary from emp table?..

Answer / gayathri

select max(salary ) from emp table where sal<(select max
(salary)from emp table)

Is This Answer Correct ?    754 Yes 97 No

how to find the second highest salary from emp table?..

Answer / bipin

use this query. it works great.

select max(sal) from table_name where sal<(select max(sal)
from table_name)

Is This Answer Correct ?    415 Yes 59 No

how to find the second highest salary from emp table?..

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

how to find the second highest salary from emp table?..

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

how to find the second highest salary from emp table?..

Answer / muhammed zaheer

select max(sal) from emp where sal < (select max(sal) from
emp)

Is This Answer Correct ?    86 Yes 16 No

how to find the second highest salary from emp table?..

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

how to find the second highest salary from emp table?..

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

how to find the second highest salary from emp table?..

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

how to find the second highest salary from emp table?..

Answer / radha sri seshu

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

Post New Answer

More SQL PLSQL Interview Questions

how to return query output in html format? : Sql dba

0 Answers  


What is mdf ldf and ndf?

0 Answers  


How can we store rows in PL/SQL using array?

0 Answers   MCN Solutions,


Why does sql need a server?

0 Answers  


package specification-3 procedures package body-4 procedures how can i write for other procedure in package body

2 Answers   Reliance,






I want to execute a piece of code before calling a procedure. How to achieve it?

1 Answers   Oracle,


What are sql data types?

0 Answers  


What is sql basics?

0 Answers  


what is a primary key? : Sql dba

0 Answers  


How can we make an if statement within a select statement?

0 Answers  


In a Distributed Database System Can we execute two queries simultaneously ? Justify ?

3 Answers  


Can function return multiple values in sql?

0 Answers  


Categories