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 are the uses of factor1, factor2 and result field for the rpg operation code parm?

0 Answers   IBM,

List the steps/commands necessary to accomplish the following: a. Copy data from the file ORDHDR into file ORDHIST b. The file ORDHIST may or may not exist c. If the file ORDHDR does exist, it may or may not contain data d. The file ORDHIST may or may not contain data, if the file does contain data the old data should be erased

1 Answers  

define a shared access path?

1 Answers   IBM,

What is the Function of PDM?

1 Answers  

How many MONMSG commands can declare in a CL program?

3 Answers  

if dspatr(pc) and csrloc were specified for a format, which keyword would have priority?

1 Answers   IBM,

what does check opcode is used?

1 Answers   IBM,

What are all the different types of access path?

1 Answers  

I need to insert a record in a file using STRSQL containing the some field values same as an already existing record in that file.I know to smple insert mentioning those values one by one.But is there any another query can be prepared for the same .Please share the query if known to you. Thanks in advance.

0 Answers   CSC,

what is sflpag and sflsiz ?

2 Answers   IBM,

1) Suppose we call a pgm from CL, how come AS400 system knows whether the called pgm is to be interactive one or batch one? 2)How many members can exist in a PF?

7 Answers  

How to see active jobs of the system.

1 Answers