write the SQL statement to retrieve the 2nd Highest salary
ammount(File Name="EMPLOY",Field Name="SALARY")
- 6 Answers
- 18777 Views
- Bally Technologies, Cognizant, Vertex, I also Faced
- E-Mail Answers
Answer Posted / sandeep
select top 1 salary from employee where salary<(select top 1 salary from employee order by salary desc) order by salary desc
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is file access opcodes?
what would be the effect on the field where reverse image, underline and highlight display attributes are active ?
what are the three line types in rlu ?
explain the purpose of keep and assume keywords?
what opcode could be used to test an alphanumeric field for all numeric values?
What Is The Error If We Don't Get Login Screen?
how can you specify no duplicate key?
what is a non-join logical file?
which are control break logic indicators?
which are the member types which seu supports?
what is scan and xlate?
How to convert a spool file to PDF file in AS400?
what is the purpose of the indara keyword?
can a single screen format occupy a screen area above and below a subfile format ?
what are the different opcodes available in rpg for database access ?
