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
- 20828 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 Does 'sr' In Columns 7-8 Of C Specs Mean?
different type of cursor?
the maximum number of subfiles that can be active for a single file is ____ .
how to read database records without locking them?
1. There is a file called Month. Month has 12 members called Jan, Feb, ..., Dec. How to design a rpg code which can access any member and show its content. (User can ask for any member when required)?
what is match field indicator?
what opcode will be used to test the zone of a character field?
in which specification the report layout can be defined?
how do you specify page overflow indicator for printer files in rpg?
how you will find an error which is not in the first page of the subfile without using rolldown key?
what are the various types of device files?
how can I predict the performance of my cgis?
what is subfile?
What is compiler directive in as400? Give example of compiler directive.?
Difference between NOPASS & OMIT?
