How to read 2nd highest sal from EMP table?

Categories >> Software >> Databases >> SQL Server
Suggest New Category

Question Posted / mohanasam

5 Answers
6319 Views
IBM, TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to read 2nd highest sal from EMP table?..

Answer / sasikala

select max(salary) from emp where salary<(select max(salary) from emp);

Is This Answer Correct ?

11 Yes

0 No

How to read 2nd highest sal from EMP table?..

Answer / b.kumar

-- USING MS SQL SERVER

SELECT TOP 1 FROM

( SELECT DISTINCT TOP 2 FROM EMP ORDER BY SAL DESC) EMP
ORDER BY SAL ASC

Is This Answer Correct ?

2 Yes

0 No

How to read 2nd highest sal from EMP table?..

Answer / gali kondareddy

SELECT * FROM EMP WHERE SAL =(SELECT MIN(SAL) FROM EMP WHERE SAL IN (SELECT TOP 2 SAL FROM EMP ORDER BY SAL DESC))

Is This Answer Correct ?

1 Yes

0 No

How to read 2nd highest sal from EMP table?..

Answer / sheshu4040

SELECT MAX(EMP_SALARY) FROM EMP
WHERE EMP_SALARY NOT IN (SELECT MAX(EMP_SALARY) FROM EMP)

Is This Answer Correct ?

0 Yes

0 No

How to read 2nd highest sal from EMP table?..

Answer / arnab bhui

Using Oracle........

create table emp
( id number(10),
sal numeric(10,5)
);

SQL> select max(sal) from (( select sal from emp ) minus ( select sal from emp where sal >= all ( select sal from emp )));

Is This Answer Correct ?

1 Yes

2 No

Post New Answer