write the SQL statement to retrieve the 2nd Highest salary
ammount(File Name="EMPLOY",Field Name="SALARY")
- 6 Answers
- 18776 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
Apart from opening of a file do we have any other use of USROPN?
how do handle file exception/error?
can we define multi-dimensional arrays in rpg ?
using dfu, user will be able to ___________ from physical file?
what if my system I runs with system value qccsid 65535?
What Is Ddm ?
What Is Default Data Type (if You Define Decimals '0') In Physical File?
How we will get issues on AS/400 technology ? I mean which issue/Defect Tracking tool is using in all companies when any issue comes? Can anybody explain about the work flow of AS/400 project ? plzzz
how does union file maintains record formats?
what does check opcode do ?
what is overlay?
how can database records be read without lock ?
how can a message from a message file appear as a constant on the screen?
what is the difference between sflclr and sflinz?
what are various techniques to pass parameters from one program to another?
