Write a query to find second highest salary of an employee.

Question Posted / mreddy

Answers were Sorted based on User's Feedback

Write a query to find second highest salary of an employee. ..

Answer / preetir

select min(sal) from (select distinct sal from emp order by
desc where rownum < 2)

Is This Answer Correct ?

0 Yes

2 No

Write a query to find second highest salary of an employee. ..

Answer / arif saulat

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

Is This Answer Correct ?

0 Yes

2 No

Write a query to find second highest salary of an employee. ..

Answer / deepshikha

SELECT MAX (sal)
FROM emp a,
(SELECT MAX (sal) max_sal
FROM emp) abc
WHERE a.sal < abc.max_sal
ORDER BY sal DESC;

Is This Answer Correct ?

0 Yes

3 No

Write a query to find second highest salary of an employee. ..

Answer / vamana murthy

select ename,salary from emp
where rownum=2
order by salary desc

Is This Answer Correct ?

0 Yes

7 No

Write a query to find second highest salary of an employee. ..

Use the below Query:

Select Max(salary) from Emp
Where Max(salary) < (Select Max(salary) from emp
where emp-no=101);

Is This Answer Correct ?

10 Yes

18 No

Write a query to find second highest salary of an employee. ..

Answer / kitcat

SELECT salary
FROM (SELECT salary FROM emp
ORDER BY DESC salary)
WHERE RowNum=2

Is This Answer Correct ?

1 Yes

11 No

Write a query to find second highest salary of an employee. ..

Answer / jeff

select max(salary)
from Emp
where rownum < 2;

Is This Answer Correct ?

3 Yes

19 No