Skip to Content
0
Former Member
Jan 18, 2010 at 04:12 PM

Max Count

472 Views

Hi,

i'm a newbie in Abap-Development but I Have developed in some other languages.

My Problem is, that I have to select the max count of a table like this:

Select tab1-field1 max( Count( tab2-field1 ) ) from tab1 inner join tab2 on tab1-field1 = tab2-field2 group by tab1-field1

In single steps:

What I want to see, is the maximum count of tab2-field1 in relation to tab1-field1. How can I do this? In Abap I can not write this sql, because ofter the max is an field expected, am i right?

Thanks,

Peter