Skip to Content
0
Former Member
Jul 19, 2007 at 03:57 PM

duplicate max values

36 Views

Hallo

i'm doing a select for a max-value in a column of a table. i'm getting the highest value exists twice (in two rows) and the rc that i get is 4. how can i get both rows in an internal table? or can i specify more tahn 1 column to find only one max-value.

the first column is a date, the second i could use would be a time-field.

my select-statement:

SELECT * FROM yvtebstg

INTO CORRESPONDING FIELDS OF TABLE lt_ebstg

WHERE polnr = ls_vermitt-polnr

AND temudat = ( select MAX( temudat ) FROM yvtebstg ).

many thanks, martin.