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
- 20373 Views
- Bally Technologies, Cognizant, Vertex, I also Faced
- E-Mail Answers
Answer Posted / yogesh
This is correct answer -Try it
SELECT SALARY FROM EMPLOYEE WHERE SALARY < (SELECT MAX
(SALARY) FROM EMPLOYEE) ORDER BY SALARY DESC FETCH FIRST 1
ROW ONLY
| Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
give three main purposes of file specification ?
how to write code for singlepage in sqlrpgle with update ?
what is the use of dspatr(mdt) keyword?
what is the maximum number of files allowed in rpg?
what is full form for dds?
How to convert a spool file to PDF file in AS400?
What Does 'sr' In Columns 7-8 Of C Specs Mean?
which of the cl command can be used to determine which logical files are dependent on a specific file?
what is a keyed physical file?
What is the use of jdftval in as400?
which single rpg opcode performs both setll and reade?
how you get the relative record in a subfile in which cursor is located?
what is maximum number of arrays allowed in rpg?
what is arrival sequence?
what are the basic features of seu?
