simple select query..

[Former Member]

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]

Select MAX(C1)

into var_c1

from T1

where <your condition>.

regards

Nishant

[Former Member]

Thanks..

[Former Member]

tables T1.

data tvbak like vbak-vbeln.

Select max( C1 )

from T1 into tvbak.

write tvbak.

[Former Member]

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]

Select MAX(C1)

into var_c1

from T1

where <your condition>

GROUP BY C1.

This will work..

Reward points if it helps