write the SQL statement to retrieve the 2nd Highest salary
ammount(File Name="EMPLOY",Field Name="SALARY")
Answer Posted / 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
| Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
What are the mandatory keywords of sub file?
can a single screen format occupy a screen area above and below a subfile format ?
What are the types of data structure in as400?
how can you execute a command from within an rpg program without calling a clp program?
what are the basic features of seu?
The content of Physical file is as below: hfcftp wruquief SENDPASV 0 CDUP ASCII GET 01100901.CSV ramndk/ECP505.EC0110090 (REPLACE QUIT Thw above commands will get executed when we call STRTCPFTP from CL program.... Now if I want to use SFTP what can be the solution? plz reply in detail....Thank you for ny help... I m using RPG/ILERPG to download...
Apart from opening of a file do we have any other use of USROPN?
what does the ovrdbf command do?
How Many Specs Are There In Rpg & Which Are They?
what is message file?
how can a message from a message file appear as a constant on the screen?
how many printer files can be defined in f specs ?
What is file information data structure(infds) in as400?
how to declare a constant variable in the freeformat?
What Is Ddm ?