select with aggregate function MAX

[Former Member]

Hi,

Can I write a query like:

select field1 field2 MAX( field3 )

from z_table

into table itab

for all entries in itab2

where field1 = itab2-field1

and field2 = itab2-field2.

In the above case all the 3 fields are key fields.

Thanks in advance.

[Former Member]

Why dont you try to execute it and check if its working?

[Former Member]

hi

try this

select , max() as field2, min() as field3, ...

from........

[Former Member]

Hi,

I did try it.. but got an error like: "The field "z_table~field2" from the select list is missing in the GROUP BY clause" but my aggregate funtion is used only for the field3..... So, I wanted to know if anybody has come across such a query....

Thanks,

[rainer_hbenthal]

If there is only one max function in the select you do not need a group by. In your case, you need one. But this was told you by the compiler....

[ThomasZloch]

Check online help for aggregate functions. All selected columns which are not used as aggregate functions must appear in the GROUP BY clause.

Thomas

[Former Member]

Hi All,

The code works fine after the group by clause.

Thanks for your help.

Thanks,

Sindhu