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
- 20563 Views
- Bally Technologies, Cognizant, Vertex, I also Faced
- E-Mail Answers
Answer Posted / yogesh
This is correct answer -Try it
SELECT SALARY FROM EMPLOYEE WHERE SALARY < (SELECT MAX
(SALARY) FROM EMPLOYEE) ORDER BY SALARY DESC FETCH FIRST 1
ROW ONLY
| Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
what does defn do?
what are dds required for subfile?
what is the syntax for plist?
What are the different opcodes used for file operation on a subfile in a rpg pgm?
describe the difference between the dowxx and douxx operations?
what is a spool file?
Difference Between Interactive & Batch Job?
What are the types of data structure in as400?
maximum number of subfiles that can be active for a single file is?
what is arrival sequence?
what is term cua , saa?
define the purpose of the leave operation?
what is sflinz and sflrna?
define a shared access path?
can you display a empty subfile?
