Select max(salary) from file where salary not in (select max(Salary) from f

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

Question Posted / vivek dwivedi

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

Please Help Members By Posting Answers For Below Questions

What is data structure in as400? What is the use of data structure?

1085

define subsystem?

1624

What Is Ddm ?

1696

what is the disadvantage of using global variable?

1210

what is a non-join logical file?

1824

what is the maximum number of records you can specify in a display file?

1870

define what a data area is along with a brief example of what it may be used for?

1731

the maximum number of subfiles that can defined in a rpg program for one display file is ___ .

3286

how to declare a constant variable in the freeformat?

1402

what is the difference between *like and *namvar ?

2542

when should I use method get, and when should I use method post in my cgis?

1136

how can I start a page in a new window?

1223

when would you prefer logical file than opnqryf?

2443

What is array in as400? What are the types of array?

1114

Difference Between Interactive & Batch Job?

1236