write the SQL statement to retrieve the 2nd Highest salary
ammount(File Name="EMPLOY",Field Name="SALARY")
- 6 Answers
- 18779 Views
- Bally Technologies, Cognizant, Vertex, I also Faced
- E-Mail Answers
Answer Posted / aravind.r
select min(SALARY) from EMPLOY where SALARY in
(select top 2 SALARY from EMPLOY order by SALARY desc)
| Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
WHAT IS AS/400 SYNORIO?
what is a logical file?
what is a physical file?
what is sflrolval?
How to reverse the string in rpg
In AS/400 projects in Companies whats the meaning of production support team.what production support involves.also what work does development,maintenance involve what are the other teams or processes that are available for as400 project.
Difference Between Ca & Cf?
what is a composite key?
how many files can be defined in f specs?
which of the cl command can be used to determine which logical files are dependent on a specific file?
what is *inzsr used for?
what opcode could be used to test an alphanumeric field for all numeric values?
what is the purpose of ovrdta (override data) keyword?
can error messages as a result of a comp, range or values keyword be overridden?
explain the purpose of keep and assume keywords?
