JCR-SQL2 : paging

[Clemens Wyss - MySign AG]

how would you implement paging with JCR-SQL2? Im looking for MySQL's LIMIT 
equivalent. Or is there a "JCR pattern" for paging?

Thx in advance