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
- 20610 Views
- Bally Technologies, Cognizant, Vertex, I also Faced
- E-Mail Answers
Answer Posted / aravind.r
select min(SALARY) from EMPLOY where SALARY in
(select top 2 SALARY from EMPLOY order by SALARY desc)
| Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
In AS/400 projects in Companies whats the meaning of production support team.what production support involves.also what work does development,maintenance involve what are the other teams or processes that are available for as400 project.
which indicator is used for read?
How do you check object lock
can a join logical file be updated?
how you get the relative record in a subfile in which cursor is located?
distinguish between terminating a program through seton lr and return?
what is the version of os/400 that we have?
what are the different types of arrays available in rpg ?
which of the cl command can be used to determine which logical files are dependent on a specific file?
In 'o' Specs What Is The Opcode For Write?
What is the as400 called now?
what are different types of substems?
what is the function of cpysplf command?
define what a data area is along with a brief example of what it may be used for?
what are the two record formats a subfile contain ?
