(ABAP 코드) DISTINCT, GROUP BY, APPENDING

- DISTINCT

예제1) DISTINCT 사용

SELECT DISTINCT, CARRID, CONNID
FROM SCARR
INTO TABLE @DATA(GT_ITAB).

예제2) DELETE ADJACENT DUPLICATES 사용

* SORTED 테이블을 사용하던지, SORT을 사용해서 정렬하자.
SORT GT_ITAB BY CARRID CONNID.

SELECT CARRID, CONNID
FROM SCARR
INTO TABLE @GT_ITAB.

DELETE ADJACENT DUPLICATES FROM GT_ITAB.

 

- GROUP BY

SELECT CARRID, CONNID, SUM( SEATSOCC ), COUNT( * ) AS TOTAL
FROM SFLIGHT
INTO TABLE @DATA(GT_ITAB)
GROUP BY CARRID, CONNID
HAVING SUM( SEATSOCC ) > 2000
AND COUNT( * ) > 10
AND CARRID = 'AA'.

 

- APPENDING

SELECT CARRID, CONNID, FLDATE, SEATSMAX, SEATSOCC
FROM SFLIGHT APPENDING TABLE @DATA(GT_ITAB)
*FROM SFLIGHT APPENDING CORRESPONDING FIELDS OF TABLE @GT_ITAB.
WHERE CARRID = 'LH'.