Select querry for maximum value

[Former Member]

Hi,

I want to select fields A B C D from a database table TAB using some selection criteria from selection screen, but the greatest value of A has to be selected for all unique entries of B C and D. Please suggest an appropriate select querry.

PS: I cannot use SELECT and then DELETE ADJACENT DUPLICATES as it will effect performance in some cases.

Regards.

[Former Member]

Try using aggregate function MAX with SELECT statement.

MAX Returns the greatest value in the column determined by the database field f for the selected lines. Specifying DISTINCT does not change the result. NULL values are ignored unless all values in a column are NULL values. In this case, the result is NULL .

Have a look at below link:

[Select Clause|http://www.sts.tu-harburg.de/teaching/sap_r3/ABAP4/select_c.htm]

I hope it helps.

Best Regards,

Vibha

Please mark all the helpful answers

[Former Member]

Try using aggregate function MAX with SELECT statement.

MAX Returns the greatest value in the column determined by the database field f for the selected lines. Specifying DISTINCT does not change the result. NULL values are ignored unless all values in a column are NULL values. In this case, the result is NULL .

Have a look at below link:

[Select Clause|http://www.sts.tu-harburg.de/teaching/sap_r3/ABAP4/select_c.htm]

I hope it helps.

Best Regards,

Vibha

Please mark all the helpful answers

[Former Member]

hi Charles,

do this way

 select max( a ) from <table> into table itab where <conditons> ..
 

Regards,

Santosh