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

is it possible to create a physical file without dds?

1 Answers   IBM,

can a single screen format occupy a screen area above and below a subfile format ?

1 Answers   IBM,

when are the unique constraints executed?

0 Answers   IBM,

What is the purpose of the following? I 'CLOSED' C STAT01 I 'OPEN' C STAT02

1 Answers  

What is the purpose of the following C/COPY QRPGSRC, ORDERR

1 Answers  

is it possible to create a join logical file using two join logical files ? give exact reason for your answer

4 Answers   Ocwen,

what are the parameters required for calling ls & get command(SFTP COMMANDS) from cl progtram.... e.g call PGM(qp2shell) PARM('/qopensys/usr/bin/sh' '-c' 'sftp -b /home/mydir/tmp.txt user@host.com') Plz reply in detail...

1 Answers  

What is the use of Data Queues?

1 Answers  

what is the purpose of putovr (put with explicit override) keyword?

1 Answers   IBM,

Write a logic program for knowing the repeated number of a vowels in a given program?

0 Answers   Valtech,

when do you explicitly open files and close files in an rpg program?

1 Answers   IBM,

what is scan and xlate?

1 Answers   IBM,