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
- 20587 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 'sr' In Columns 7-8 Of C Specs Mean?
which type of object is used in db2/400?
what are indicators?
Difference between NOPASS & OMIT?
how will you find a string using pdm?
which indicator is used for read?
how you will find an error which is not in the first page of the subfile without using rolldown key?
define subsystem?
Can we debug the MSGW JOBS?
is their a difference in cobol400 for the release 5.2 and 6.1 at the as400.
what is rpg fixed logic cycle?
how can I give more performance to some selected pages?
What is data structure in as400? What is the use of data structure?
difference between sflrcdnbr and sflnxtchg?
How can we change the uppercase to Lowercase in RPG?
