Mastering SAP ABAP

GROUP BY

The GROUP BY clause combines identical content in columns specified by a GROUP BY clause, or content that has the same result in a SQL expression for a single row.

The GROUP BY clause combines identical content in columns specified by a GROUP BY clause, or content that has the same result in a SQL expression for a single row:

SELECT carrid connid   FROM sflight   INTO CORRESPONDING FIELDS OF TABLE gt_sflight    GROUP BY carrid connid.

The result of that query is as follows:

As you can see, the result set is pretty much the same in that example as when we use SELECT DISTINCT. However, in GROUP BY, we can also specify a field with an IS NOT ...