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
how many types of display are available on as/400 for user interaction?
which type of object is used in db2/400?
what opcode will be used to test the zone of a character field?
WHAT IS AS/400 SYNORIO?
what are different types of substems?
Difference Between Call & Sbmjob?
when would you prefer logical file than opnqryf?
what is the maximum number of fields under a record format of physical file?
I need to insert a record in a file using STRSQL containing the some field values same as an already existing record in that file.I know to smple insert mentioning those values one by one.But is there any another query can be prepared for the same .Please share the query if known to you. Thanks in advance.
what are the three line types in rlu ?
what is the maximum number of subfiles that can specified in a display file ?
what is message subfile?
how do you know that records are locked?
when do you explicitly open files and close files in an rpg program?
what is the function of crtdupobj command?