Limiting the result set with TOP and LIMIT

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

With 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.