ABAP Keyword Documentation →  ABAP − Reference →  Processing External Data →  ABAP Database Access →  ABAP SQL →  ABAP SQL - Reads 

SELECT clauses

This section describes the possible clauses and additions, which are possible for the SELECT statements of main queries and subqueries. Information on which clauses are possible in which queries can be found in the relevant statements and clauses.

• SINGLE

• FROM

• FIELDS

• SELECT clause

• FOR ALL ENTRIES

• WHERE

• GROUP BY

• HAVING

• ORDER BY

• INTO|APPENDING

• UP TO, OFFSET

• abap_options

Other versions: 7.31 | 7.40 | 7.54

Continue

SELECT - SINGLE

SELECT - FROM

SELECT - FIELDS

SELECT - select_clause

SELECT - FOR ALL ENTRIES

SELECT - WHERE

SELECT - GROUP BY

SELECT - HAVING

SELECT - ORDER BY

SELECT - INTO, APPENDING

SELECT - UP TO, OFFSET

SELECT - abap_options