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
- 20821 Views
- Bally Technologies, Cognizant, Vertex, I also Faced
- E-Mail Answers
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 is the difference between normal upddta to pf and updating using dfu program?
what is join logical file?
using dfu, user will be able to ___________ from physical file?
how can I control from my cgis the cache of a remote browser?
how can a message from a message file appear as a constant on the screen?
why is as/400 called object oriented machine?
what are the different commands used in rlu ?
how to toggle between single line and multi - line display of a particular record in a subfile?
how many printer files can be defined in f specs ?
what is the clp command to access a query/400?
what is the version of os/400 that we have?
What is data structure in as400? What is the use of data structure?
How Many Specs Are There In Rpg & Which Are They?
what does the ovrdbf command do?
What is file access opcodes?
