finding maximium value fo ra field in the Z table created in se11

[Former Member]

hi,

i have a field called ZID in the zdetails table which i have created in se11.

hw can i find the maximum value of that field out of the records filled in?

thanks in advancce

[Former Member]

tables : ZDETAILS.

select max( ZID ) into ZDETAILS-ZID from ZDETAILS.

write : / ZDETAILS-ZID.

regards

shiba dutta

[Former Member]

Hi

try this..

DATA : zid like zdetails-zid.

select max( ZID ) into ZID from zdetails

where <cond>.

Message was edited by:

Perez C

[Former Member]

DATA : zid type i.

select max( ZID ) from zdetails into zid GROUP BY zid.

write: zid.