Interface SelectBuilder.SelectFromAndJoinCondition
- All Superinterfaces:
SelectBuilder.BuildSelect
,SelectBuilder.SelectJoin
,SelectBuilder.SelectLimitOffset
,SelectBuilder.SelectLock
,SelectBuilder.SelectOnCondition
,SelectBuilder.SelectOrdered
,SelectBuilder.SelectWhere
- Enclosing interface:
- SelectBuilder
public static interface SelectBuilder.SelectFromAndJoinCondition
extends SelectBuilder.BuildSelect, SelectBuilder.SelectJoin, SelectBuilder.SelectWhere, SelectBuilder.SelectOnCondition, SelectBuilder.SelectLimitOffset, SelectBuilder.SelectLock
Builder exposing
FROM
, WHERE
, LIMIT/OFFSET
, JOIN AND
and LOCK
continuation
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.Methods inherited from interface org.springframework.data.relational.core.sql.SelectBuilder.BuildSelect
build
Methods inherited from interface org.springframework.data.relational.core.sql.SelectBuilder.SelectJoin
join, join, leftOuterJoin
Methods inherited from interface org.springframework.data.relational.core.sql.SelectBuilder.SelectLock
lock
Methods inherited from interface org.springframework.data.relational.core.sql.SelectBuilder.SelectOnCondition
and
Methods inherited from interface org.springframework.data.relational.core.sql.SelectBuilder.SelectOrdered
orderBy, orderBy, orderBy
Methods inherited from interface org.springframework.data.relational.core.sql.SelectBuilder.SelectWhere
where
-
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)
.- Specified by:
limitOffset
in interfaceSelectBuilder.SelectLimitOffset
- Parameters:
limit
- rows to read.offset
- row offset, zero-based.- Returns:
this
builder.
-
limit
Apply a limit of rows to read.- Specified by:
limit
in interfaceSelectBuilder.SelectLimitOffset
- Parameters:
limit
- rows to read.- Returns:
this
builder.
-
offset
Apply an offset where to start reading rows.- Specified by:
offset
in interfaceSelectBuilder.SelectLimitOffset
- Parameters:
offset
- start offset.- Returns:
this
builder.
-