write the SQL statement to retrieve the 2nd Highest salary
ammount(File Name="EMPLOY",Field Name="SALARY")
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
which are the member types which seu supports?
when do you use f-spec. Continuation line ?
can we define multi-dimensional arrays in rpg ?
is there any way to dynamically merge other html scripts into a given html?
Space & Skip Are Which Level Keywords?
In 'o' Specs What Is The Opcode For Write?
define data structure?
name few ibm supplied libraries?
if dspatr(pc) and csrloc were specified for a format, which keyword would have priority?
what is the use of sflend keyword?
how do you read data area in an rpg program?
what is the function of crtdupobj command?
any one have give AS400 study material? pls pass it to gopalsai789@gmail.com
what are the three types of keywords associated with printer file ?
How to reverse a string using RPG?