select min(SALARY) from EMPLOY where SALARY in (select top 2 SALARY from E

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

Question Posted / aravind.r

Answer Posted / aravind.r

select min(SALARY) from EMPLOY where SALARY in
(select top 2 SALARY from EMPLOY order by SALARY desc)

Is This Answer Correct ?

7 Yes

5 No

Please Help Members By Posting Answers For Below Questions

how can I predict the performance of my cgis?

1051

Apart from opening of a file do we have any other use of USROPN?

1336

what is the use of data structures?

1089

what does opcode post do ?

1711

is it possible, in the same cgi, to run more than one gethtml or gethtmlifs?

1015

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

3215

How to reverse a string using RPG?

1410

What is RETURN CURSER LOCATION in subfile?

1539

WHAT IS FERERENTIAL INTRIGRITY ?

1579

how to get the cursor position?

1095

during input operation which indicator position is seton if there is a record lock?

1529

how many types of display are available on as/400 for user interaction?

1068

how can we run a batch job?

1120

how to validate input values in display file ?

1155

what is the use of jdftval in join logical file?

1742