Skip Navigation

Newer Version Available

This content describes an older version of this product. View Latest

offset

Paginates values from query results.

Syntax

1result = offset rows number;

Usage

Used to paginate values from query results. This statement requires that the data has been ordered with the order statement.

Example

This example loads a dataset, puts the rows in descending order, and returns rows 400 to 800:

1a = load "0Fbxx000000002qCAA/0Fcxx000000002WCAQ";
2b = foreach a generate 'carrier' as 'carrier', count() as 'count';
3c = order b by 'count' desc;
4d = offset c 400;
5e = limit d 400;