write the SQL statement to retrieve the 2nd Highest salary ammount(File Name=&

Categories >> Software >> MainFrame >> IBM AS400 >> IBM AS400 AllOther
Suggest New Category

write the SQL statement to retrieve the 2nd Highest salary
ammount(File Name="EMPLOY",Field Name="SALARY")

Question Posted / girilakshmi

6 Answers
20583 Views
Bally Technologies, Cognizant, Vertex, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

write the SQL statement to retrieve the 2nd Highest salary ammount(File Name="EMPLOY",Fi..

Answer / kamal

hi,
select max(salary) from empfile where salary <(select max
(salary from empfile))

or

select salary from empfile a 2=(select count(salary) from
from empfile b where b.salary>=a.salary)

Is This Answer Correct ?

24 Yes

2 No

write the SQL statement to retrieve the 2nd Highest salary ammount(File Name="EMPLOY",Fi..

Answer / yogesh

This is correct answer -Try it

SELECT SALARY FROM EMPLOYEE WHERE SALARY < (SELECT MAX
(SALARY) FROM EMPLOYEE) ORDER BY SALARY DESC FETCH FIRST 1
ROW ONLY

Is This Answer Correct ?

13 Yes

2 No

write the SQL statement to retrieve the 2nd Highest salary ammount(File Name="EMPLOY",Fi..

Answer / aravind.r

select min(SALARY) from EMPLOY where SALARY in
(select top 2 SALARY from EMPLOY order by SALARY desc)

Is This Answer Correct ?

7 Yes

5 No

write the SQL statement to retrieve the 2nd Highest salary ammount(File Name="EMPLOY",Fi..

Answer / sandeep

select top 1 salary from employee where salary<(select top 1 salary from employee order by salary desc) order by salary desc