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"; 
2    b = foreach a generate 'carrier' as 'carrier', count() as 'count';
3    c = order b by 'count' desc;
4    d = limit c 400; 
5    e = offset d 400;