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 the two record formats a subfile contain ?
What is dynslt?
Difference Between Call & Sbmjob?
distinguish between terminating a program through seton lr and return?
how do you specify the number of records to roll in a subfile ?
what the purpose of ovrdta, ovrata keywords?
what is the purpose of ovrdta (override data) keyword?
A join logical file has how many record formats?
What is the as400 called now?
what is a program described file in rpg?
what is the purpose of dynslt keyword?
What is the difference between iter and do? We know both are used to execute set of statements repeatedly, but what is the main difference?
http default port 80 is used by some other production http service. How can I create an http instance on another port to run cgidev2 and my future cgi developments?
How we will get issues on AS/400 technology ? I mean which issue/Defect Tracking tool is using in all companies when any issue comes? Can anybody explain about the work flow of AS/400 project ? plzzz
what is the purpose of putovr (put with explicit override) keyword?