Select MAX()

[Former Member]

Hello!

What's here wrong? My program says there is a error.

SELECT MAX( price ) INTO wa2 FROM zaa_sflight.

Thanks!

[former_member200338]

Hi,

try this.

data l_max type zaa_sflight-price.

SELECT single MAX( price ) INTO l_max FROM zaa_sflight.

Regards,

Niyaz

Sorry: Change data type.

Edited by: Niyaz Ahamed on Jan 18, 2008 4:41 PM

[former_member188829]

hi,

SELECT MAX( price ) INTO wa2 FROM zaa_sflight.

in the above statement write like this..

MAX( space price space )

[Former Member]

check type of price

[Former Member]

Hi,

Check the following code:

tables: sflight.

data: airfare like sflight-price.

select MAX( price ) into airfare from sflight.

write airfare.

Regards,

Bhaskar

[Former Member]

hi,

check that u have missed period for the above statement

regards

zubair