Interface SelectBuilder.SelectLimitOffset
- All Known Subinterfaces:
SelectBuilder.SelectFromAndJoin
,SelectBuilder.SelectFromAndJoinCondition
,SelectBuilder.SelectFromAndOrderBy
- Enclosing interface:
- SelectBuilder
public static interface SelectBuilder.SelectLimitOffset
Limit/offset methods.
-
Method Summary
Modifier and TypeMethodDescriptionlimit
(long limit) Apply a limit of rows to read.limitOffset
(long limit, long offset) Applylimit
andoffset
parameters to the select statement.offset
(long offset) Apply an offset where to start reading rows.
-
Method Details
-
limitOffset
Applylimit
andoffset
parameters to the select statement. To read the first 20 rows from start uselimitOffset(20, 0)
. to read the next 20 uselimitOffset(20, 20)
.- Parameters:
limit
- rows to read.offset
- row offset, zero-based.- Returns:
this
builder.
-
limit
Apply a limit of rows to read.- Parameters:
limit
- rows to read.- Returns:
this
builder.
-
offset
Apply an offset where to start reading rows.- Parameters:
offset
- start offset.- Returns:
this
builder.
-