Interested to Buy Any Domain ? << Click Here >> for more details...
write the SQL statement to retrieve the 2nd Highest salary
ammount(File Name="EMPLOY",Field Name="SALARY")
- 6 Answers
- 20612 Views
- Bally Technologies, Cognizant, Vertex, I also Faced
- E-Mail Answers
Answer Posted / 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)
| Is This Answer Correct ? | 24 Yes | 2 No |
Post New Answer View All Answers
define the rcvf command?
how can I control from my cgis the cache of a remote browser?
what is the use of dspatr(mdt) keyword?
explain the difference between defining subfile and message-subfile?
how do you read data area in an rpg program?
what is *inzsr used for?
what is the maximum number of records you can specify in a display file?
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...
how do you specify page overflow indicator for printer files in rpg?
What Is The Difference Between Goto & Exsr?
Explain this error: "all record formats for externally-described file abcd ignored or dropped due to error; file ignored."?
Service Program : S1 Modules in S1 : M1 M1 having two procedures : ADD, SUB Current Binder Language STRPGMEXP PGMLVL(*CURRENT) EXPORT SYMBOL("ADD") EXPORT SYMBOL("SUB") ENDPGMEXP Doubt: I need to add one new Module to the Service Program M2 having one procedure ‘MULT’ How to add this new module to the service program S1 ? If I need to recreate the service program again, Do I need to mention the Module M1 again while recreating along with new Module M2? There is no Binding Directory. Binder language structure will be like this STRPGMEXP PGMLVL(*CURRENT) EXPORT SYMBOL("ADD") EXPORT SYMBOL("SUB") EXPORT SYMBOL("MULT") ENDPGMEXP STRPGMEXP PGMLVL(*PREVIOUS) EXPORT SYMBOL("ADD") EXPORT SYMBOL("SUB") ENDPGMEXP
what is the sequence when using cursor?
any one have give AS400 study material? pls pass it to gopalsai789@gmail.com
is it possible, in the same cgi, to run more than one gethtml or gethtmlifs?
