This is correct answer -Try it SELECT SALARY FROM EMPLOYEE WHERE SALARY

write the SQL statement to retrieve the 2nd Highest salary
ammount(File Name="EMPLOY",Field Name="SALARY")

Question Posted / yogesh

6 Answers
20834 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

Please Help Members By Posting Answers For Below Questions

How can we arrange duplicate records in a file?

1132

what is a physical file?

1903

how to toggle between single line and multi - line display of a particular record in a subfile?

1896

difference between view and index ?

1204

what is the use of sflend keyword?

1931

How to avoid using indicators in ile ?

1321

which type of object is used in db2/400?

1103

records can be read/update/deleted with which file?

1126

what is a non-join logical file?

1925

what does the ovrdbf command do?

1170

in which specification the report layout can be defined?

1703

how do handle file exception/error?

1229

which are the query selection criteria, which can be given in a query?

1216

what is a logical file?

1918

What are the mandatory keywords of sub file?

1537