Interface SelectBuilder
public interface SelectBuilder
Entry point to construct a
Select
statement.- Since:
- 1.1
- Author:
- Mark Paluch, Jens Schauder, Myeonghyeon Lee
- See Also:
-
Nested Class Summary
Modifier and TypeInterfaceDescriptionstatic interface
Interface exposing theSelect
build method.static interface
Builder exposingSELECT
andFROM
methods.static interface
Builder exposingFROM
methods.static interface
Builder exposingFROM
,JOIN
,WHERE
,LIMIT/OFFSET
andLOCK
methods.static interface
Builder exposingFROM
,WHERE
,LIMIT/OFFSET
, JOINAND
andLOCK
continuation methods.static interface
Builder exposingFROM
,JOIN
,WHERE
,LIMIT/OFFSET
andLOCK
methods.static interface
Interface exposingJOIN
methods.static interface
Limit/offset methods.static interface
Lock methods.static interface
Interface exposingON
methods to declareJOIN
relationships.static interface
Builder exposing JOIN andJOIN … ON
continuation methods.static interface
Interface declaring the target column comparison relationship.static interface
Builder exposingORDER BY
andLOCK
methods.static interface
Interface exposingWHERE
,LOCK
methods.static interface
-
Method Summary
Modifier and TypeMethodDescriptiondistinct()
Makes the select statement distinctselect
(Collection<? extends Expression> expressions) Include one or moreExpression
s in the select list.select
(Expression expression) Include aExpression
in the select list.select
(Expression... expressions) Include one or moreExpression
s in the select list.top
(int count) Apply aTOP
clause givencount
.
-
Method Details
-
top
Apply aTOP
clause givencount
.- Parameters:
count
- the top count.- Returns:
this
SelectBuilder
.
-
select
Include aExpression
in the select list.- Parameters:
expression
- the expression to include.- Returns:
this
builder.- See Also:
-
select
Include one or moreExpression
s in the select list.- Parameters:
expressions
- the expressions to include.- Returns:
this
builder.- See Also:
-
select
Include one or moreExpression
s in the select list.- Parameters:
expressions
- the expressions to include.- Returns:
this
builder.- See Also:
-
distinct
SelectBuilder.SelectAndFrom distinct()Makes the select statement distinct- Returns:
this
builder.
-