how to get second highest salary in SQL(as/4000

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

Question Posted / guest

29 Answers
32114 Views
iGate, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to get second highest salary in SQL(as/4000..

Answer / siva kumar yachamaneni

select max(salary) from Employee where salary<(SELECT
max(salary) from Employee)

Is This Answer Correct ?

0 Yes

1 No

how to get second highest salary in SQL(as/4000..

Answer / prabir

Select * From employee emp1 Where 2 = (Select
Count(Distinct(emp1.salary)) From employee emp2 Where
emp2.salary > emp1.salary)

Is This Answer Correct ?

3 Yes

5 No

how to get second highest salary in SQL(as/4000..

Answer / shasi

select sal from emp a where &n=(select count(sal) from emp
b where a.sal>=b.sal)
First u enter 1 means 1st highest sal.then enter2 2nd
highest sal

Is This Answer Correct ?

1 Yes

3 No

how to get second highest salary in SQL(as/4000..

Answer / ashish raut

for 2nd highest price..............

SELECT max(Price) as [MaxPrice] from OrderDetails
where Price<(SELECT max(Price)as MaxPrice from OrderDetails)

for 3rd highest Price........

SELECT max(Price) as [MaxPrice] from OrderDetails
where Price<(SELECT max(Price)as MaxPrice from OrderDetails
where price<(SELECT max(Price)as MaxPrice from OrderDetails))

Is This Answer Correct ?

0 Yes

2 No

how to get second highest salary in SQL(as/4000..

Answer / praveen

select * from emp where max(sal)
where rownow=2

Is This Answer Correct ?

0 Yes

2 No

how to get second highest salary in SQL(as/4000..

Answer / apurva

Select *
From (
Select *
From (select * from emp order by sal desc)
Where rownum < 3 order by sal) ---> n+1 for example for
secound you should use 3
Where rownum < 2

Is This Answer Correct ?

4 Yes

7 No

how to get second highest salary in SQL(as/4000..

Answer / sachin bhalsinge

select * from (select salary from employees order by salary
desc)where rownum=2;

Is This Answer Correct ?

5 Yes

11 No

how to get second highest salary in SQL(as/4000..

Answer / ramesh.p

Select salary
From ( Select salary from emp order by salary desc)
Where rownum =2;

Is This Answer Correct ?

10 Yes

19 No

how to get second highest salary in SQL(as/4000..

Answer / siddhartha

select sal, ename from employee where ROWNUM = 2 order by
sal;

Is This Answer Correct ?

12 Yes

36 No

Post New Answer