write the SQL statement to retrieve the 2nd Highest salary
ammount(File Name="EMPLOY",Field Name="SALARY")
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 ? | 12 Yes | 2 No |
Post New Answer View All Answers
what are members?
how to read database records without locking them?
What is binder language ?
how can I automatically refresh a web page?
what is the difference between packed decimal and zoned decimal?
Write a CL program which will run a batch job at 1 am every night
Difference Between Ca & Cf?
how to toggle between single line and multi - line display of a particular record in a subfile?
how would you design the process for a nightly, high volume check producing process that needs to select only records that are flagged to be processed?
In RPG How to read a records from a file without using read opcodes?
records can be read/update/deleted with which file?
is there any way I can ease my rpg controls on numeric input fields? How about an input date field?
what is the favicon.ico request that my site receives now and then?
what keyword must be used with protect keyword ?
explain the purpose of keep and assume keywords?