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
- 20569 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 is sflpag and sflsiz ?
what does vldcmdkey means?
name few ibm supplied libraries?
what is the version of os/400 that we have?
which are the figurative constants used in rpg?
what is the disadvantage of using global variable?
what is the purpose of ovrdta and ovrata keywords ?
How can we change the uppercase to Lowercase in RPG?
what is the difference between udate and the system date?
maximum number of subfiles that can defined in a rpg program for one display file is?
what is *inzsr used for?
define subsystem?
what are the various types of device files?
how do you use exceptional write in c specs?
how do you read changed records backward in subfile?
