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
- 20588 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 maximum number of record formats in dspf?
different type of cursor?
is there any way I can ease my rpg controls on numeric input fields? How about an input date field?
What is diff between EVAL & MOVE?
what is rpg ?
what is the necessary keyword for non-join logical file?
define the purpose of the iter operation?
maximum number of subfiles that can defined in a rpg program for one display file is?
what is sflpag and sflsiz ?
which are the query selection criteria, which can be given in a query?
how you get the relative record in a subfile in which cursor is located?
what are the basic features of seu?
What are the mandatory keywords of sub file?
how does union file maintains record formats?
when do you explicitly open files and close files in an rpg program?
