write the SQL statement to retrieve the 2nd Highest salary
ammount(File Name="EMPLOY",Field Name="SALARY")
- 6 Answers
- 18780 Views
- Bally Technologies, Cognizant, Vertex, I also Faced
- E-Mail Answers
Answer Posted / vivek dwivedi
Select max(salary) from file where salary not in (select max(Salary) from file)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are necessary keywords to code message subfile?
how to validate input values in display file ?
how you get the relative record in a subfile in which cursor is located?
How can we change the uppercase to Lowercase in RPG?
what is sflpag and sflsiz ?
what is rpg ?
how many printer files maximum can be used in single rpg program?
how to get the cursor position?
how many files can be defined in f specs?
what is the purpose of ovrdta and ovrata keywords ?
what is the maximum number of parameters allowed in rpg?
using dfu, user will be able to ___________ from physical file?
what are all the contents of subfile?
What is RETURN CURSER LOCATION in subfile?
the maximum number of subfiles that can defined in a rpg program for one display file is ___ .
