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

What is dynslt?

0 Answers  

I have SQLRPGLE program in which there are some update statements which executed correctly. there were no errors run time. Once the program gets over, the file was not updated with the new values. What might be the reason?

2 Answers  

When will DUMP and DEBUG opcodes be ignored?

1 Answers  

How to genarate the reports?

1 Answers  

how to validate input values in display file ?

0 Answers   IBM,

what is a logical file?

1 Answers   IBM,

What is source physical file?

1 Answers  

what is the use of UNIQUEUE KEY WORD? what is the difference between PFILE AND REF?

2 Answers  

how many maximum spaces could be given in o specs?

0 Answers   IBM,

how can I start a page in a new window?

0 Answers   IBM,

what is default data type for the fields(sub fields) defined in data structures in rpg?

2 Answers   IBM,

define what a data queue is along with a brief example of what it may be used for?

1 Answers   IBM,