write the SQL statement to retrieve the 2nd Highest salary
ammount(File Name="EMPLOY",Field Name="SALARY")
Answer Posted / suresh miryala
select top 1 from (select top 2 from emp order by sal desc)A
order by sal
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
what are the three types of keywords associated with printer file ?
how can we run a batch job?
define data structure?
what keyword must be used with protect keyword ?
what are the limitations of cl (compare to rpg) ?
How to add 99 menu (page down) option in menu creation..
any one have give AS400 study material? pls pass it to gopalsai789@gmail.com
How can we change the uppercase to Lowercase in RPG?
what is overlay?
how can I control the way a remote browser uses its cache?
what is xfoot opcode ?
using dfu, user will be able to ___________ from physical file?
can a join logical file be updated?
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...
what is the syntax for plist?