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
- 20827 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
what is a physical file?
difference between sflrcdnbr and sflnxtchg?
what does check opcode do ?
Write a logic program for knowing the repeated number of a vowels in a given program?
what are the two record formats a subfile contain ?
what is logical file?
what is the difference between *like and *namvar ?
In Which Specs Arrays, Tables & Constants Are Defined?
WHICH REPLY CODE IS USED BT sftp ? ... (e.g.226 is used by FTP IF FILE IS TRANSFERED)
which are the relational operators in rpg?
how to read database records without locking them?
what is a query can be run in which mode?
different type of cursor?
can you have multiple key lists for a single file ?
how can a cgi check whether an ifs object is available?
