May 2019
Beginner to intermediate
548 pages
12h 39m
English
UP TO (natural number) ROWS is used for defining a limit in terms of the number of rows that can be selected in SELECT:
SELECT carrid connid planetype UP TO 10 ROWS FROM sflight INTO CORRESPONDING FIELDS OF TABLE gt_sflight.
In this example, we will get the first 10 rows:

Read now
Unlock full access