write the SQL statement to retrieve the 2nd Highest salary
ammount(File Name="EMPLOY",Field Name="SALARY")
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 are various techniques to pass parameters from one program to another?
What are the different opcodes used for file operation on a subfile in a rpg pgm?
what is the purpose of ovrdta (override data) keyword?
hi guys i am new for sqlrpgle, please suggest me good websites and theory and coding. plz plz its very urgent.
in conjunction with what other keyword must ovrdta and ovrata be used?
when are the referential constraints executed?
in which specification the report layout can be defined?
define a output queue?
can you have multiple key lists for a single file ?
Difference Between Call & Sbmjob?
What is the difference between crtdupobj and copyf?
what is maximum number of arrays allowed in rpg?
what does vldcmdkey means?
what is a physical file?
What is difference between rename and prefix?