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

If I want to execute Sftp commands(LS & GET) stored in Physical file from CL program automatically...Can u Plz tell me how can I do this?...How the script will look?? THANX FOR NY HELP...

0 Answers  

I am a fresher. I got project on AS 400. Can any body suggest the best book for learning of it.

1 Answers  

Hi.can any body give me the code for this quesiton please.Because i dont have to try to enter the code in to the AS/400 server.Please can anybody give the answer for this question with complete code? A smple RPLE pgm which accepts the starting number and ending number as parameter.It then has to count all the odd numbers b/w the accepted range of numbers and display the results/ Ex:if the input parameters are 11 and 30 the result should be 10(11,13,15,17,19,21,23,25,27,29) Please explain and give me the complete code?

2 Answers   Bally Technologies,

What is the difference between Physical and Logical files ?

1 Answers  

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

0 Answers  

how to get the particular field's records in CL without using OVRDBF,OPNQRY? tell me the concept?

2 Answers  

Q. HOw can read multimember file through RPG/400 and CL/400 Actully i know that we can Read multimember file in RPG through EXEFILE and EXEMBR and in cl through OVRDBF and MEMBER(3)....But i want to read 3 members by CL Program And RPG/400 program.Please write the coding(Program) for both RPG/400 and CL/400 programs? 2.What are the full forms(stands) of EXEFILE and EXEMBR?

5 Answers   CTS,

how to validate input values in display file ?

0 Answers   IBM,

Why do you use Keep and Assume Keywords.

2 Answers   Four soft,

how to define to define a hidden filed in dspf ?

0 Answers   IBM,

how do we know batch job aborted after we submitting it

1 Answers  

if &var='good++++' &var2='day' &var *cat &var2 &var1 *tcat &var2 what is output

2 Answers