topic Re: Row having higher date. in Application Development and Automation Discussions

Row having higher date.

Former Member — Wed, 16 Aug 2006 10:10:21 GMT

hi.

am fetching data from a table where threr are 4 rows having same values in each column, only date in each row is different. I have to select only row which has higher date.How can i do this??

Re: Row having higher date.

Former Member — Wed, 16 Aug 2006 10:11:23 GMT

select max(date)

field1

field2

from <table>

into wa_table

where <where condition>.

another example:

<i><b>DATA: name TYPE scustom-name,

postcode TYPE scustom-postcode,

city TYPE scustom-city,

max TYPE sbook-loccuram.

SELECT scustom_{name scustom}postcode scustom~city

MAX( sbook~loccuram )

INTO (name, postcode, city, max)

FROM scustom INNER JOIN sbook

ON scustom_{id = sbook}customid

WHERE sbook~fldate BETWEEN '20010101' AND '20011231' AND

sbook~carrid = 'LH ' AND

sbook~connid = '0400'

GROUP BY scustom_{name scustom}postcode scustom~city

ORDER BY scustom~name.

WRITE: / name, postcode, city, max.

ENDSELECT.</b></i>

Regards,

Ravi

Re: Row having higher date.

Former Member — Wed, 16 Aug 2006 10:13:43 GMT

Use select Max(date) ......into table itab etc.

hope it works.

cheers.

santosh

Re: Row having higher date.

Former Member — Wed, 16 Aug 2006 10:14:49 GMT

SELECT SINGLE F1 F2 ... MAX( DATE ) FROM TABLE INTO WA_ITAB.

Re: Row having higher date.

Former Member — Wed, 16 Aug 2006 10:15:43 GMT

HI,

You can use aggregate function MAX.

select max(date_fld) from table into v_maxdate.

if sy-subrc = 0.

select * from table where date_fld = v_maxdate.

endif.

Regards,

Sailaja.

Re: Row having higher date.

Former Member — Wed, 16 Aug 2006 10:16:47 GMT

Hi,

Select all the dates into an internal table, sort the internal table on Date field descending, this will get the max.date value on top, the rest can be deleted from the internal table using delete statement using index numbers,

Hope this helps,

Rgds,