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
- 20296 Views
- Bally Technologies, Cognizant, Vertex, I also Faced
- E-Mail Answers
Answer Posted / vivek dwivedi
Select max(salary) from file where salary not in (select max(Salary) from file)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What Is Ddm ?
can we define multi-dimensional arrays in rpg ?
difference between view and index ?
What is the difference between physical file and logical file?
is there any way to dynamically merge other html scripts into a given html?
WHICH REPLY CODE IS USED BT sftp ? ... (e.g.226 is used by FTP IF FILE IS TRANSFERED)
where can you specify an indicator in lokup operation?
what do we can do with the embedded sql statements?
what is match field indicator?
how do you use exceptional write in c specs?
how to get the cursor position?
what is the maximum number of record formats in dspf?
what does defn do?
what the purpose of ovrdta, ovrata keywords?
what is the maximum number of subroutines allowed in rpg?
