Open SQL group by 的使用

方式一：

data : begin of line,
        carrid like sflight-carrid,
        minimum type p decimals 2,
        maximum type p decimals 2,
      end of line.
data : itab like table of line,
      iab_wa like line of itab.
data : minimum type p decimals 2 ,maximum type p decimals 2.
select carrid min( price ) max( price )
    into table itab
  from sflight
  group by carrid.
  loop at itab into iab_wa .
    write : / iab_wa-carrid ,iab_wa-minimum,iab_wa-maximum.
   endloop.

方式二：

tables : sflight.
data : carrid like sflight-carrid.
data : minimum type p decimals 2 ,maximum type p decimals 2 .
select carrid min( price )  max( price )
        into (carrid , minimum , maximum)
  from sflight group by carrid.

  write : / carrid ,minimum ,maximum .
endselect.