Interface SelectBuilder.SelectFromAndJoin
- All Superinterfaces:
SelectBuilder.BuildSelect
,SelectBuilder.SelectFrom
,SelectBuilder.SelectFromAndOrderBy
,SelectBuilder.SelectJoin
,SelectBuilder.SelectLimitOffset
,SelectBuilder.SelectLock
,SelectBuilder.SelectOrdered
,SelectBuilder.SelectWhere
- Enclosing interface:
- SelectBuilder
public static interface SelectBuilder.SelectFromAndJoin
extends SelectBuilder.SelectFromAndOrderBy, SelectBuilder.BuildSelect, SelectBuilder.SelectJoin, SelectBuilder.SelectWhere, SelectBuilder.SelectLimitOffset, SelectBuilder.SelectLock
Builder exposing
FROM
, JOIN
, WHERE
, LIMIT/OFFSET
and LOCK
methods.-
Method Summary
Modifier and TypeMethodDescriptionfrom
(Collection<? extends TableLike> tables) Declare one or moreTable
s toSELECT … FROM
.Declare aTable
toSELECT … FROM
.Declare one or moreTable
s toSELECT … FROM
.limit
(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.SelectFromAndOrderBy
from, orderBy, orderBy, orderBy
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.SelectWhere
where
-
Method Details
-
from
Declare aTable
toSELECT … FROM
. Multiple calls to this or otherfrom
methods keep adding items to the select list and do not replace previously contained items.- Specified by:
from
in interfaceSelectBuilder.SelectFrom
- Specified by:
from
in interfaceSelectBuilder.SelectFromAndOrderBy
- Parameters:
table
- the table toSELECT … FROM
must not be null.- Returns:
this
builder.- See Also:
-
from
Declare one or moreTable
s toSELECT … FROM
. Multiple calls to this or otherfrom
methods keep adding items to the select list and do not replace previously contained items.- Specified by:
from
in interfaceSelectBuilder.SelectFrom
- Specified by:
from
in interfaceSelectBuilder.SelectFromAndOrderBy
- Parameters:
tables
- the tables toSELECT … FROM
must not be null.- Returns:
this
builder.- See Also:
-
from
Declare one or moreTable
s toSELECT … FROM
. Multiple calls to this or otherfrom
methods keep adding items to the select list and do not replace previously contained items.- Specified by:
from
in interfaceSelectBuilder.SelectFrom
- Specified by:
from
in interfaceSelectBuilder.SelectFromAndOrderBy
- Parameters:
tables
- the tables toSELECT … FROM
must not be null.- Returns:
this
builder.- See Also:
-
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.SelectFromAndOrderBy
- 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.SelectFromAndOrderBy
- 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.SelectFromAndOrderBy
- Specified by:
offset
in interfaceSelectBuilder.SelectLimitOffset
- Parameters:
offset
- start offset.- Returns:
this
builder.
-