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
- 20613 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
distinguish between terminating a program through seton lr and return?
how you get the relative record in a subfile in which cursor is located?
What is the as400 called now?
What are the mandatory keywords of sub file?
how to pick up the changed records every time in a subfile after the first change made ?
What is data structure in as400? What is the use of data structure?
define the purpose of the leave operation?
what is the difference between sflclr and sflinz?
Write a logic program for knowing the repeated number of a vowels in a given program?
What are the different opcodes used for file operation on a subfile in a rpg pgm?
what do we can do with the embedded sql statements?
what is the function of cpyf command?
what is the function of cpysplf command?
what is the use of data structures?
what is join logical file?
