Row max value

[mastercontrol]

Hi,

I need to get max value of all rows + value of next row

Example:

w1 w2 w3 w4 w5
1 2 3 4 5

Max Value = 5
+ value from max Value + next row = 6

So, should show value of 6.

 

[ultimategc3]

Declare a new function

Long ll_value

SELECT Max(col_name)
INTO :ll_value
FROM tab_name;

Return ll_value + 1


Regards...

 

[mastercontrol]

Thanks a lot! Perfect solution.