|
最后忠于不报错了:
TABLES SBOOK.
DATA: AACOUNT TYPE I,AASUM TYPE P DECIMALS 2,AAAVG TYPE F.
DATA: CONNID LIKE SBOOK-CONNID.
SELECT CONNID, COUNT( * ), SUM( LUGGWEIGHT ), AVG( LUGGWEIGHT ) INTO (@CONNID,@AACOUNT,@AASUM,@AAAVG)
FROM SBOOK
GROUP BY CONNID.
WRITE: / CONNID,AACOUNT,AASUM,AAAVG. ",AACOUNT,AASUM,AAAVG
*CHECK AASUM > 40.
*WRITE: / ' THE SUM WEITHT>40'.
ENDSELECT.
WRITE: / 'ok '.
|
|