topic Re: Select MAX() in Application Development and Automation Discussions

Select MAX()

Former Member — Fri, 18 Jan 2008 10:50:38 GMT

Hello!

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

SELECT MAX( price ) INTO wa2 FROM zaa_sflight.

Thanks!

Former Member — Fri, 18 Jan 2008 10:52:49 GMT

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 — Fri, 18 Jan 2008 10:59:56 GMT

hi,

SELECT MAX( price ) INTO wa2 FROM zaa_sflight.

in the above statement write like this..

MAX( space price space )

Former Member — Fri, 18 Jan 2008 11:01:43 GMT

check type of price

Former Member — Fri, 18 Jan 2008 11:10:29 GMT

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 — Fri, 18 Jan 2008 11:14:24 GMT

hi,

check that u have missed period for the above statement

regards

zubair