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
- 20820 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
what key word is used when screen is re-display?
what is sflinz and sflrna?
Difference Between Skip Before & Space Before?
Hello, I have created a CMD type object. In one of the fields in Display file , I would like to see All the Source files present by pass the name of Library. Tried using CHoice(Keyword) and Choicepgm on PARM , but doesn't seems to be working. Any help please..
where can you specify an indicator in lokup operation?
What is difference between rename and prefix?
can we use ASCII ,CDUP,SENDPASV commands in SFTP?
what is sflpag and sflsiz ?
which cl command can be used at program execution to redirect the file named in an rpg program?
What is the draw back of Procedures? why we are going to Modules?
What is the maximum number of subfiles that can be specified in a display file?
what is the maximum number of subroutines allowed in rpg?
what is the function of crtdupobj command?
How to Define a Procedure in RPG?
Explain The Keywords Edtcde & Edtwrd?
