Which clause is used to group records based on specified criteria in an ABAP SELECT statement?

The clause used to group records based on specified criteria in an ABAP SELECT statement is indeed GROUP BY. This clause is essential when you want to aggregate results from your database based on one or more columns. When using GROUP BY, you can apply aggregate functions such as SUM, COUNT, AVG, etc., to summarize your data effectively.

For example, if you want to calculate the total sales for each product category, you would group the records by the product category. The result set would then provide one record for each category, along with the aggregate values calculated for that group.

The other clauses serve different purposes within a SQL query. ORDER BY is used to sort the result set, HAVING is used to filter groups after the aggregation has been performed, and WHERE is used to filter records before any grouping occurs. Therefore, GROUP BY is the appropriate choice for grouping records based on specific criteria within an ABAP SELECT statement.