Sometimes we don’t want to see all the data that would be found based on our filter conditions. For example, in our HANA Web Console, results are basically limited to a maximum of 1000 records. This is sufficient for our purposes, no one wants to see more records in our examples anyway.
The first X records with TOP
SELECT TOP <Anzahl> <Feldliste> we get the first records according to the number. If no sort order is specified with ORDER BY, these are random records.
Forming Packages with LIMIT and OFFSET
The addition LIMIT <Number> at the very end of a query initially has the same effect as the TOP <Number> shown above. The difference is, that after LIMIT also an OFFSET <lines>can be specified. This will then skip the lines. So you can pick up data in multiple packets.