write the SQL statement to retrieve the 2nd Highest salary
ammount(File Name="EMPLOY",Field Name="SALARY")
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 ? | 12 Yes | 2 No |
Post New Answer View All Answers
what are the three line types in rlu ?
how do u compile rpgle program?
a multiple format logical file is also known as?
what is service program?
what is externally described file ?
In Which Specs Arrays, Tables & Constants Are Defined?
What is data structure in as400? What is the use of data structure?
how to pick up the changed records every time in a subfile after the first change made ?
how to validate input values in display file ?
what is a composite key?
what does the ovrdbf command do?
what is the purpose of data structure?
how to declare a constant variable in the freeformat?
What Does 'sr' In Columns 7-8 Of C Specs Mean?
how to read database records without locking them?