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
- 20611 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
which are the string manipulation opcodes?
How to reverse a string using RPG?
how can database records be read without lock ?
What is data structure in as400? What is the use of data structure?
what is a keyed physical file?
what does dfu program you to do on a record?
what is the command to know key fields of file?
how to write code for singlepage in sqlrpgle with update ?
what is the purpose of putovr (put with explicit override) keyword?
what keyword must be used with protect keyword ?
how may a cgi control duplicate inputs?
what does the opcode free do?
which cl command can be used at program execution to redirect the file named in an rpg program?
what are the important factors in error message subfile ?
how can you execute a command from within an rpg program without calling a clp program?
