SAP HANA: LIMIT with OFFSET keywords

LIMIT:

The limit keyword is used to limit the number of rows returned in a  query result. 

SYNTAX:

LIMIT <unsigned_integer>

EXAMPLE:

select * from "KABIL_PRACTICE"."OFFSET"  limit 4;

RESULT:

LIMIT with OFFSET:

Returns the first <unsigned_integer> grouped records after skipping OFFSET<unsigned_integer> for each grouping set.

SYNTAX:

LIMIT <unsigned_integer> [OFFSET <unsigned_integer>]

EXAMPLE:

select * from "KABIL_PRACTICE"."OFFSET"  limit 4 offset 2;

RESULT: