topic Re: Select querry for maximum value in Application Development and Automation Discussions

Select querry for maximum value

Former Member — Fri, 02 May 2008 12:58:45 GMT

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.

Re: Select querry for maximum value

Former Member — Fri, 02 May 2008 13:03:40 GMT

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

Re: Select querry for maximum value

Former Member — Fri, 02 May 2008 13:04:37 GMT

hi Charles,

do this way


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

Regards,

Santosh