topic Re: Select MAX not working properly in Application Development and Automation Discussions

Select MAX not working properly

Former Member — Fri, 24 May 2019 13:44:59 GMT

Hi,

I am writing the following select statement and it is returning wrong value.

Select max( QMNUM ) from QMEL into (lv_qmnum) groupby qmnum.

Is it because the field qmnum is of type char. I also tried without groupby.

Thanks,

Vinod.

Re: Select MAX not working properly

Nawanandana — Fri, 24 May 2019 14:24:22 GMT

Hi,

you should used Select group by otherwise it will be wrong anyway.

If you used aggregate function like(SUM,MAX....) with the group by you have to put rest of the field with group by close . I mean rest of the all field with group by.

"DEPT", SUM("SALARY") from"KABIL_PRACTICE"."DEMO_EMP"Groupby"DEPT";

"here with group by you have to put only 'DEPT' not SALARY. because SALARY goes with aggregate function.

https://help.sap.com/viewer/7c78579ce9b14a669c1f3295b0d8ca16/Cloud/en-US/0579a6540e89468998e0ecfaff69acb0.html

Regards,

Nawa.

Re: Select MAX not working properly

SimoneMilesi — Fri, 24 May 2019 15:44:37 GMT

Read and analyze your code.

You are selecting the max value QMNUM inside a group formed by QMNUM, so, basically, you are doing a select single.. since QMNUM is the split criteria.

Re: Select MAX not working properly

Sandra_Rossi — Fri, 24 May 2019 19:45:00 GMT

I don't have any error with the code you mention, and it does what any SQL developer would expect. A character field is not an issue for MAX:

DATA lv_qmnum TYPE qmel-qmnum.
SELECT MAX( qmnum ) FROM qmel INTO (lv_qmnum).

Re: Select MAX not working properly

DoanManhQuynh — Sat, 25 May 2019 12:01:41 GMT

how wrong it return?