topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Sat, 05 Jan 2008 06:44:27 GMT

Hi,

How can i get the maximum number of one field using select statement..

Former Member — Sat, 05 Jan 2008 06:46:15 GMT

Can u clarify ur doubt plz?

Regards,

Talwinder

Former Member — Sat, 05 Jan 2008 06:48:25 GMT

use aggregate fn max

select max( field ) from.........

Former Member — Sat, 05 Jan 2008 06:48:43 GMT

HI,

do like this.

DATA: M_TABLE TYPE TABNAME,

COLUMN_FIELD(14) TYPE C,

VALUE2(10)." TYPE P DECIMALs 1.

M_TABLE = 'MARA'.

COLUMN_FIELD = 'MATNR'."example 2.1

SELECT MAX( MATNR ) FROM (M_TABLE) INTO VALUE2.

write:/ value2.

In general

SELECT MAX( COLUMN_FIELD ) FROM (M_TABLE) INTO VALUE2.

rgds,

arpit_shah — Sat, 05 Jan 2008 06:50:53 GMT

try like this,

MAX (field): The maximum value of the field

eg.

SELECT MAX (field)

INTO (W_MAX)

FROM table

ENDSELECT.

Regards,

Arpit.