topic Re: simple select query.. in Application Development and Automation Discussions

simple select query..

Former Member — Mon, 29 Oct 2007 06:11:45 GMT

Hi All,

Please tell me how can i fetch a single record having maximum value for a particular column ( aggregate function MAX ).

assume that the table name = T1 and column name = C1

Thanks in Advance, Sudeep..

Former Member — Mon, 29 Oct 2007 06:14:21 GMT

Select MAX(C1)

into var_c1

from T1

where <your condition>.

regards

Nishant

Former Member — Mon, 29 Oct 2007 06:18:26 GMT

tables T1.

data tvbak like vbak-vbeln.

Select max( C1 )

from T1 into tvbak.

write tvbak.

Former Member — Mon, 29 Oct 2007 06:19:44 GMT

data: it_table type T1.

SELECT single * FROM T1

INTO TABLE it_table

WHERE C1 = ( SELECT MAX( C1 ) FROM T1 ).

LOOP AT it_table.

WRITE: it_table-C1.

ENDLOOP.

Award points if found useful

Former Member — Mon, 29 Oct 2007 06:22:00 GMT

Select MAX(C1)

into var_c1

from T1

where <your condition>

GROUP BY C1.

This will work..

Reward points if it helps

Former Member — Mon, 29 Oct 2007 06:23:14 GMT

Thanks..