To find second largest salary in Employee table

Question Posted / padmapriya

Answers were Sorted based on User's Feedback

To find second largest salary in Employee table..

Answer / anu

Select max(Sal) from emp
Where
Sal
<
(Select max(Sal) from emp);

Is This Answer Correct ?

0 Yes

0 No

To find second largest salary in Employee table..

Answer / sujith

select empname,salary from(
select empname,salary, rank() over( order by salary desc) ss from emp)
where ss=2;

Is This Answer Correct ?

3 Yes

4 No

To find second largest salary in Employee table..

Answer / ela tiku

Select Max(SAL) FROM emp WHERE sal<(SELECT MAX(SAL) FROM
emp)

<<<assuming sal is the column name and emp is the table
name>>>

Is This Answer Correct ?

0 Yes

1 No

To find second largest salary in Employee table..

Answer / kuduba.r

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

Is This Answer Correct ?

0 Yes

1 No

To find second largest salary in Employee table..

Answer / anjum

SELECT MAX(SALARY)FROM EMP WHERE SALARY(SELECT MAX(SALARY)
FROM EMP)

Is This Answer Correct ?

0 Yes

1 No

To find second largest salary in Employee table..

Answer / murugesh

select * from (select row_number over( order by salary
desc) as salcount,empid,salary from employee) emp
where emp.salcount = 2

Is This Answer Correct ?

1 Yes

2 No

To find second largest salary in Employee table..

Answer / chitharthan

select max(salary)-1 from employeetable

Is This Answer Correct ?

0 Yes

10 No