Interface SelectBuilder.SelectFromAndOrderBy
- All Superinterfaces:
SelectBuilder.BuildSelect
,SelectBuilder.SelectFrom
,SelectBuilder.SelectLimitOffset
,SelectBuilder.SelectLock
,SelectBuilder.SelectOrdered
- All Known Subinterfaces:
SelectBuilder.SelectFromAndJoin
- Enclosing interface:
- SelectBuilder
public static interface SelectBuilder.SelectFromAndOrderBy
extends SelectBuilder.SelectFrom, SelectBuilder.SelectOrdered, SelectBuilder.SelectLimitOffset, SelectBuilder.SelectLock, SelectBuilder.BuildSelect
Builder exposing
FROM
, JOIN
, WHERE
, LIMIT/OFFSET
and LOCK
methods.-
Method Summary
Modifier and TypeMethodDescriptionDeclare aTable
toSELECT … FROM
.from
(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.orderBy
(Collection<? extends OrderByField> orderByFields) Add one or moreorder by fields
.Add one or morecolumns
to order by.orderBy
(OrderByField... orderByFields) Add one or moreorder by fields
.Methods inherited from interface org.springframework.data.relational.core.sql.SelectBuilder.BuildSelect
build
Methods inherited from interface org.springframework.data.relational.core.sql.SelectBuilder.SelectLock
lock
-
Method Details
-
limitOffset
Description copied from interface:SelectBuilder.SelectLimitOffset
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
Description copied from interface:SelectBuilder.SelectLimitOffset
Apply a limit of rows to read.- Specified by:
limit
in interfaceSelectBuilder.SelectLimitOffset
- Parameters:
limit
- rows to read.- Returns:
this
builder.
-
offset
Description copied from interface:SelectBuilder.SelectLimitOffset
Apply an offset where to start reading rows.- Specified by:
offset
in interfaceSelectBuilder.SelectLimitOffset
- Parameters:
offset
- start offset.- Returns:
this
builder.
-
from
Description copied from interface:SelectBuilder.SelectFrom
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
- Parameters:
table
- the table name toSELECT … FROM
must not be null or empty.- Returns:
this
builder.- See Also:
-
from
Description copied from interface:SelectBuilder.SelectFrom
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
- Parameters:
table
- the table toSELECT … FROM
must not be null.- Returns:
this
builder.- See Also:
-
from
Description copied from interface:SelectBuilder.SelectFrom
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
- Parameters:
tables
- the tables toSELECT … FROM
must not be null.- Returns:
this
builder.- See Also:
-
from
Description copied from interface:SelectBuilder.SelectFrom
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
- Parameters:
tables
- the tables toSELECT … FROM
must not be null.- Returns:
this
builder.- See Also:
-
orderBy
Description copied from interface:SelectBuilder.SelectOrdered
Add one or morecolumns
to order by.- Specified by:
orderBy
in interfaceSelectBuilder.SelectOrdered
- Parameters:
columns
- the columns to order by.- Returns:
this
builder.
-
orderBy
Description copied from interface:SelectBuilder.SelectOrdered
Add one or moreorder by fields
.- Specified by:
orderBy
in interfaceSelectBuilder.SelectOrdered
- Parameters:
orderByFields
- the fields to order by.- Returns:
this
builder.
-
orderBy
Description copied from interface:SelectBuilder.SelectOrdered
Add one or moreorder by fields
.- Specified by:
orderBy
in interfaceSelectBuilder.SelectOrdered
- Parameters:
orderByFields
- the fields to order by.- Returns:
this
builder.
-