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)

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

Answer / aravind.r

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

Answer / sandeep

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

Answer / vivek dwivedi

Select max(salary) from file where salary not in (select max(Salary) from file)

Answer / suresh miryala

select top 1 from (select top 2 from emp order by sal desc)A
order by sal

Q.How primary file can be defined in RPG/400?Please write the senario with opcode specification?

3 Answers   Keane India Ltd,

what is the maximum number of parameters allowed in clp?

2 Answers   IBM,

what does check opcode is used?

1 Answers   IBM,

What is data structure in as400? What is the use of data structure?

0 Answers  

What is the symbol used for defining a new field in SDA?

1 Answers  

What is the difference between keys of a Physical file and the keys of a logical file?

2 Answers   Bank Of America, BoA,

how can I give more performance to some selected pages?

0 Answers   IBM,

can u plz tell me is there any difference between SHELL SCRIPT & SFTP SCRIPT? I want to run LS & GET(automatically) command from CL program....which script can be used?

1 Answers  

what is lokup opcode?

1 Answers   IBM,

How to position the cursor on a display file at a desired location.

5 Answers   Four soft,

can a indexed file be accessed in arrival sequence in rpg program?

1 Answers   IBM,

What is an ICF file?

1 Answers