select top 1 from (select top 2 from emp order by sal desc)A order by sal

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

Question Posted / suresh miryala

Answer Posted / suresh miryala

select top 1 from (select top 2 from emp order by sal desc)A
order by sal

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

what key word is used when screen is re-display?

1176

explain the difference between defining subfile and message-subfile?

1945

What Is The Object Type Of Pf, Lf, Printer File & Display File?

1197

what is the difference between sflclr and sflinz?

1844

when would you use or not use this approach?

1621

can you specify a display file to be used in the following modes input,output, or combined modes ?

1621

What is program status data structure(psds) in as400?

1134

can you display a empty subfile?

1279

what is the difference between normal upddta to pf and updating using dfu program?

1391

How Many Specs Are There In Rpg & Which Are They?

1146

why is as/400 called object oriented machine?

1774

how can I give more performance to some selected pages?

1083

define subsystem?

1705

maximum number of subfiles that can be active for a single file is?

1775

How can we change the uppercase to Lowercase in RPG?

1476