Interested to Buy Any Domain ? << Click Here >> for more details...
write the SQL statement to retrieve the 2nd Highest salary
ammount(File Name="EMPLOY",Field Name="SALARY")
- 6 Answers
- 20614 Views
- Bally Technologies, Cognizant, Vertex, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / sandeep
select top 1 salary from employee where salary<(select top 1 salary from employee order by salary desc) order by salary desc
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / vivek dwivedi
Select max(salary) from file where salary not in (select max(Salary) from file)
| Is This Answer Correct ? | 0 Yes | 0 No |
select top 1 from (select top 2 from emp order by sal desc)A
order by sal
| Is This Answer Correct ? | 1 Yes | 2 No |
Any change in service program we write binder language to allow signature change,What is the maximum number of signature change allowed in RPGLE?
3 Answers Syntel, Tech Mahindra,
what is the purpose of indicators in rpg?
when are the unique constraints executed?
What are the types of Signature validation?
how do you know that records are locked?
What are all the compiler directive statements?
how do you turn off indicators 50 through 59 in only one operation
How can we sort an array?
What Is The Difference Between Goto & Exsr?
Q.How primary file can be defined in RPG/400?Please write the senario with opcode specification?
define a output queue?
can anybody give the interview questions list of RLU. plz mail me: dinesh_sati07@yahoo.com
RPG400 
