Uses of Interface
org.jooq.ResultQuery
Package
Description
This package contains jOOQ's public API.
This package contains jOOQ's implementation classes.
-
Uses of ResultQuery in org.jooq
Modifier and TypeInterfaceDescriptioninterface
CloseableResultQuery<R extends Record>
AResultQuery
that holds a reference to the underlyingPreparedStatement
without closing it, for reuse.interface
DeleteResultStep<R extends Record>
This type is used for theDelete
's DSL API.interface
InsertResultStep<R extends Record>
This type is used for theInsert
's DSL API.interface
ASELECT
statement.interface
SelectConditionStep<R extends Record>
interface
SelectConnectByAfterStartWithConditionStep<R extends Record>
interface
SelectConnectByConditionStep<R extends Record>
interface
SelectConnectByStep<R extends Record>
interface
SelectCorrelatedSubqueryStep<R extends Record>
interface
SelectDistinctOnStep<R extends Record>
interface
SelectFinalStep<R extends Record>
interface
SelectForJSONCommonDirectivesStep<R extends Record>
interface
SelectForStep<R extends Record>
interface
SelectForUpdateOfStep<R extends Record>
interface
SelectForUpdateStep<R extends Record>
interface
SelectForUpdateWaitStep<R extends Record>
interface
SelectForXMLCommonDirectivesStep<R extends Record>
interface
SelectForXMLPathDirectivesStep<R extends Record>
interface
SelectForXMLRawDirectivesStep<R extends Record>
interface
SelectFromStep<R extends Record>
interface
SelectGroupByStep<R extends Record>
interface
SelectHavingConditionStep<R extends Record>
interface
SelectHavingStep<R extends Record>
interface
SelectIntoStep<R extends Record>
interface
SelectJoinStep<R extends Record>
interface
SelectLimitAfterOffsetStep<R extends Record>
interface
SelectLimitPercentAfterOffsetStep<R extends Record>
interface
SelectLimitPercentStep<R extends Record>
interface
SelectLimitStep<R extends Record>
interface
SelectOffsetStep<R extends Record>
interface
SelectOnConditionStep<R extends Record>
interface
SelectOptionalOnStep<R extends Record>
interface
SelectOptionStep<R extends Record>
interface
SelectOrderByStep<R extends Record>
interface
SelectQualifyConditionStep<R extends Record>
interface
SelectQualifyStep<R extends Record>
interface
SelectQuery<R extends Record>
ASELECT
statement (model API).interface
SelectSeekLimitStep<R extends Record>
interface
SelectSeekStep1<R extends Record,
T1> interface
SelectSeekStep10<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10> interface
SelectSeekStep11<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11> interface
SelectSeekStep12<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12> interface
SelectSeekStep13<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13> interface
SelectSeekStep14<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14> interface
SelectSeekStep15<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15> interface
SelectSeekStep16<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16> interface
SelectSeekStep17<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17> interface
SelectSeekStep18<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18> interface
SelectSeekStep19<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19> interface
SelectSeekStep2<R extends Record,
T1, T2> interface
SelectSeekStep20<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20> interface
SelectSeekStep21<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21> interface
SelectSeekStep22<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22> interface
SelectSeekStep3<R extends Record,
T1, T2, T3> interface
SelectSeekStep4<R extends Record,
T1, T2, T3, T4> interface
SelectSeekStep5<R extends Record,
T1, T2, T3, T4, T5> interface
SelectSeekStep6<R extends Record,
T1, T2, T3, T4, T5, T6> interface
SelectSeekStep7<R extends Record,
T1, T2, T3, T4, T5, T6, T7> interface
SelectSeekStep8<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8> interface
SelectSeekStep9<R extends Record,
T1, T2, T3, T4, T5, T6, T7, T8, T9> interface
SelectSeekStepN<R extends Record>
interface
SelectSelectStep<R extends Record>
interface
SelectStartWithStep<R extends Record>
interface
SelectUnionStep<R extends Record>
interface
SelectWhereStep<R extends Record>
interface
SelectWindowStep<R extends Record>
interface
SelectWithTiesAfterOffsetStep<R extends Record>
interface
SelectWithTiesStep<R extends Record>
interface
UpdateResultStep<R extends Record>
This type is used for theUpdate
's DSL API.Modifier and TypeMethodDescription@NotNull ResultQuery
<R> CommonTableExpression.$query()
Experimental query object model accessor method, see alsoQOM
.@NotNull ResultQuery
<R> @NotNull ResultQuery
<R> @NotNull ResultQuery
<Record> ResultQuery.coerce
(Collection<? extends Field<?>> fields) Coerce the result record type of this query to that of a set of fields.@NotNull ResultQuery
<Record> Coerce the result record type of this query to that of a set of fields.<T1> @NotNull ResultQuery
<Record1<T1>> Coerce the result record type of this query to that of a set of fields.<T1,
T2> @NotNull ResultQuery <Record2<T1, T2>> Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3>
@NotNull ResultQuery<Record3<T1, T2, T3>> Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3, T4>
@NotNull ResultQuery<Record4<T1, T2, T3, T4>> Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3, T4, T5>
@NotNull ResultQuery<Record5<T1, T2, T3, T4, T5>> ResultQuery.coerce
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5) Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3, T4, T5, T6>
@NotNull ResultQuery<Record6<T1, T2, T3, T4, T5, T6>> ResultQuery.coerce
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6) Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3, T4, T5, T6, T7>
@NotNull ResultQuery<Record7<T1, T2, T3, T4, T5, T6, T7>> ResultQuery.coerce
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7) Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3, T4, T5, T6, T7, T8>
@NotNull ResultQuery<Record8<T1, T2, T3, T4, T5, T6, T7, T8>> ResultQuery.coerce
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8) Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3, T4, T5, T6, T7, T8, T9>
@NotNull ResultQuery<Record9<T1, T2, T3, T4, T5, T6, T7, T8, T9>> ResultQuery.coerce
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9) Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10>
@NotNull ResultQuery<Record10<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>> ResultQuery.coerce
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10) Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>
@NotNull ResultQuery<Record11<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11>> ResultQuery.coerce
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11) Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>
@NotNull ResultQuery<Record12<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12>> ResultQuery.coerce
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12) Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>
@NotNull ResultQuery<Record13<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13>> ResultQuery.coerce
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13) Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>
@NotNull ResultQuery<Record14<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14>> ResultQuery.coerce
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14) Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>
@NotNull ResultQuery<Record15<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15>> ResultQuery.coerce
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15) Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>
@NotNull ResultQuery<Record16<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16>> ResultQuery.coerce
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16) Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>
@NotNull ResultQuery<Record17<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17>> ResultQuery.coerce
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17) Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>
@NotNull ResultQuery<Record18<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18>> ResultQuery.coerce
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18) Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>
@NotNull ResultQuery<Record19<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19>> ResultQuery.coerce
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19) Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>
@NotNull ResultQuery<Record20<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20>> ResultQuery.coerce
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20) Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>
@NotNull ResultQuery<Record21<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21>> ResultQuery.coerce
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21) Coerce the result record type of this query to that of a set of fields.<T1,
T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>
@NotNull ResultQuery<Record22<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, T11, T12, T13, T14, T15, T16, T17, T18, T19, T20, T21, T22>> ResultQuery.coerce
(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4, Field<T5> field5, Field<T6> field6, Field<T7> field7, Field<T8> field8, Field<T9> field9, Field<T10> field10, Field<T11> field11, Field<T12> field12, Field<T13> field13, Field<T14> field14, Field<T15> field15, Field<T16> field16, Field<T17> field17, Field<T18> field18, Field<T19> field19, Field<T20> field20, Field<T21> field21, Field<T22> field22) Coerce the result record type of this query to that of a set of fields.<X extends Record>
@NotNull ResultQuery<X> Coerce the result record type of this query to that of a table.@NotNull ResultQuery
<R> ResultQuery.fetchSize
(int rows) Specify the fetch size of the underlyingStatement
.@NotNull ResultQuery
<R> ResultQuery.intern
(int... fieldIndexes) Deprecated, for removal: This API element is subject to removal in a future version.- 3.10 - [#6254] - This functionality is no longer supported and will be removed in 4.0@NotNull ResultQuery
<R> Deprecated, for removal: This API element is subject to removal in a future version.- 3.10 - [#6254] - This functionality is no longer supported and will be removed in 4.0@NotNull ResultQuery
<R> Deprecated, for removal: This API element is subject to removal in a future version.- 3.10 - [#6254] - This functionality is no longer supported and will be removed in 4.0@NotNull ResultQuery
<R> Deprecated, for removal: This API element is subject to removal in a future version.- 3.10 - [#6254] - This functionality is no longer supported and will be removed in 4.0@NotNull ResultQuery
<R> ResultQuery.maxRows
(int rows) Specify the maximum number of rows returned by the underlyingStatement
.@Nullable ResultQuery
<?> Parser.parseResultQuery
(String sql) Parse a SQL string to a result query.@Nullable ResultQuery
<?> Parser.parseResultQuery
(String sql, Object... bindings) Parse a SQL string with bind variables to a result query.@NotNull ResultQuery
<R> ResultQuery.poolable
(boolean poolable) @NotNull ResultQuery
<R> ResultQuery.queryTimeout
(int timeout) @NotNull ResultQuery
<Record> DSLContext.resultQuery
(String sql) Create a new query holding plain SQL.@NotNull ResultQuery
<Record> DSLContext.resultQuery
(String sql, Object... bindings) Create a new query holding plain SQL.@NotNull ResultQuery
<Record> DSLContext.resultQuery
(String sql, QueryPart... parts) Create a new query holding plain SQL.@NotNull ResultQuery
<Record> DSLContext.resultQuery
(SQL sql) Create a new query holding plain SQL.@NotNull ResultQuery
<R> ResultQuery.resultSetConcurrency
(int resultSetConcurrency) Specify theResultSet
concurrency ofResultSet
objects created by jOOQ.@NotNull ResultQuery
<R> ResultQuery.resultSetHoldability
(int resultSetHoldability) Specify theResultSet
holdability ofResultSet
objects created by jOOQ.@NotNull ResultQuery
<R> ResultQuery.resultSetType
(int resultSetType) Specify theResultSet
type ofResultSet
objects created by jOOQ.Modifier and TypeMethodDescription@NotNull CreateViewFinalStep
CreateViewAsStep.as
(ResultQuery<? extends R> query) Add theAS
clause to theCREATE VIEW
statement.<R extends Record>
@NotNull CommonTableExpression<R> DerivedColumnList.as
(ResultQuery<R> query) Specify a subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record1<?>>
@NotNull CommonTableExpression<R> DerivedColumnList1.as
(ResultQuery<R> query) Specify a subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record10<?,
?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList10.as
(ResultQuery<R> query) Specify a subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record11<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList11.as
(ResultQuery<R> query) Specify a subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record12<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList12.as
(ResultQuery<R> query) Specify a subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record13<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList13.as
(ResultQuery<R> query) Specify a subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record14<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList14.as
(ResultQuery<R> query) Specify a subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record15<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList15.as
(ResultQuery<R> query) Specify a subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record16<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList16.as
(ResultQuery<R> query) Specify a subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record17<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList17.as
(ResultQuery<R> query) Specify a subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record18<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList18.as
(ResultQuery<R> query) Specify a subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record19<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList19.as
(ResultQuery<R> query) Specify a subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record2<?,
?>>
@NotNull CommonTableExpression<R> DerivedColumnList2.as
(ResultQuery<R> query) Specify a subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record20<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList20.as
(ResultQuery<R> query) Specify a subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record21<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList21.as
(ResultQuery<R> query) Specify a subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record22<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList22.as
(ResultQuery<R> query) Specify a subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record3<?,
?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList3.as
(ResultQuery<R> query) Specify a subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record4<?,
?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList4.as
(ResultQuery<R> query) Specify a subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record5<?,
?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList5.as
(ResultQuery<R> query) Specify a subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record6<?,
?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList6.as
(ResultQuery<R> query) Specify a subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record7<?,
?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList7.as
(ResultQuery<R> query) Specify a subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record8<?,
?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList8.as
(ResultQuery<R> query) Specify a subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record9<?,
?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList9.as
(ResultQuery<R> query) Specify a subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record>
@NotNull CommonTableExpression<R> Name.as
(ResultQuery<R> query) Specify a subselect to refer to by theName
to form a common table expression.@NotNull WithStep
WithAsStep.as
(ResultQuery<?> query) Associate a subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep1.as
(ResultQuery<? extends Record1<?>> query) Associate a subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep10.as
(ResultQuery<? extends Record10<?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep11.as
(ResultQuery<? extends Record11<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep12.as
(ResultQuery<? extends Record12<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep13.as
(ResultQuery<? extends Record13<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep14.as
(ResultQuery<? extends Record14<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep15.as
(ResultQuery<? extends Record15<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep16.as
(ResultQuery<? extends Record16<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep17.as
(ResultQuery<? extends Record17<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep18.as
(ResultQuery<? extends Record18<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep19.as
(ResultQuery<? extends Record19<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep2.as
(ResultQuery<? extends Record2<?, ?>> query) Associate a subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep20.as
(ResultQuery<? extends Record20<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep21.as
(ResultQuery<? extends Record21<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep22.as
(ResultQuery<? extends Record22<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep3.as
(ResultQuery<? extends Record3<?, ?, ?>> query) Associate a subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep4.as
(ResultQuery<? extends Record4<?, ?, ?, ?>> query) Associate a subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep5.as
(ResultQuery<? extends Record5<?, ?, ?, ?, ?>> query) Associate a subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep6.as
(ResultQuery<? extends Record6<?, ?, ?, ?, ?, ?>> query) Associate a subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep7.as
(ResultQuery<? extends Record7<?, ?, ?, ?, ?, ?, ?>> query) Associate a subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep8.as
(ResultQuery<? extends Record8<?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep9.as
(ResultQuery<? extends Record9<?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a subselect with a common table expression's table and column names.<R extends Record>
@NotNull CommonTableExpression<R> DerivedColumnList.asMaterialized
(ResultQuery<R> query) Specify a materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record1<?>>
@NotNull CommonTableExpression<R> DerivedColumnList1.asMaterialized
(ResultQuery<R> query) Specify a materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record10<?,
?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList10.asMaterialized
(ResultQuery<R> query) Specify a materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record11<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList11.asMaterialized
(ResultQuery<R> query) Specify a materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record12<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList12.asMaterialized
(ResultQuery<R> query) Specify a materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record13<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList13.asMaterialized
(ResultQuery<R> query) Specify a materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record14<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList14.asMaterialized
(ResultQuery<R> query) Specify a materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record15<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList15.asMaterialized
(ResultQuery<R> query) Specify a materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record16<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList16.asMaterialized
(ResultQuery<R> query) Specify a materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record17<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList17.asMaterialized
(ResultQuery<R> query) Specify a materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record18<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList18.asMaterialized
(ResultQuery<R> query) Specify a materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record19<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList19.asMaterialized
(ResultQuery<R> query) Specify a materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record2<?,
?>>
@NotNull CommonTableExpression<R> DerivedColumnList2.asMaterialized
(ResultQuery<R> query) Specify a materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record20<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList20.asMaterialized
(ResultQuery<R> query) Specify a materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record21<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList21.asMaterialized
(ResultQuery<R> query) Specify a materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record22<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList22.asMaterialized
(ResultQuery<R> query) Specify a materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record3<?,
?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList3.asMaterialized
(ResultQuery<R> query) Specify a materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record4<?,
?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList4.asMaterialized
(ResultQuery<R> query) Specify a materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record5<?,
?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList5.asMaterialized
(ResultQuery<R> query) Specify a materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record6<?,
?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList6.asMaterialized
(ResultQuery<R> query) Specify a materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record7<?,
?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList7.asMaterialized
(ResultQuery<R> query) Specify a materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record8<?,
?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList8.asMaterialized
(ResultQuery<R> query) Specify a materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record9<?,
?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList9.asMaterialized
(ResultQuery<R> query) Specify a materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record>
@NotNull CommonTableExpression<R> Name.asMaterialized
(ResultQuery<R> query) Specify a materialized subselect to refer to by theName
to form a common table expression.@NotNull WithStep
WithAsStep.asMaterialized
(ResultQuery<?> query) Associate a materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep1.asMaterialized
(ResultQuery<? extends Record1<?>> query) Associate a materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep10.asMaterialized
(ResultQuery<? extends Record10<?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep11.asMaterialized
(ResultQuery<? extends Record11<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep12.asMaterialized
(ResultQuery<? extends Record12<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep13.asMaterialized
(ResultQuery<? extends Record13<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep14.asMaterialized
(ResultQuery<? extends Record14<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep15.asMaterialized
(ResultQuery<? extends Record15<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep16.asMaterialized
(ResultQuery<? extends Record16<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep17.asMaterialized
(ResultQuery<? extends Record17<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep18.asMaterialized
(ResultQuery<? extends Record18<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep19.asMaterialized
(ResultQuery<? extends Record19<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep2.asMaterialized
(ResultQuery<? extends Record2<?, ?>> query) Associate a materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep20.asMaterialized
(ResultQuery<? extends Record20<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep21.asMaterialized
(ResultQuery<? extends Record21<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep22.asMaterialized
(ResultQuery<? extends Record22<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep3.asMaterialized
(ResultQuery<? extends Record3<?, ?, ?>> query) Associate a materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep4.asMaterialized
(ResultQuery<? extends Record4<?, ?, ?, ?>> query) Associate a materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep5.asMaterialized
(ResultQuery<? extends Record5<?, ?, ?, ?, ?>> query) Associate a materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep6.asMaterialized
(ResultQuery<? extends Record6<?, ?, ?, ?, ?, ?>> query) Associate a materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep7.asMaterialized
(ResultQuery<? extends Record7<?, ?, ?, ?, ?, ?, ?>> query) Associate a materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep8.asMaterialized
(ResultQuery<? extends Record8<?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep9.asMaterialized
(ResultQuery<? extends Record9<?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a materialized subselect with a common table expression's table and column names.<R extends Record>
@NotNull CommonTableExpression<R> DerivedColumnList.asNotMaterialized
(ResultQuery<R> query) Specify a non-materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record1<?>>
@NotNull CommonTableExpression<R> DerivedColumnList1.asNotMaterialized
(ResultQuery<R> query) Specify a non-materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record10<?,
?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList10.asNotMaterialized
(ResultQuery<R> query) Specify a non-materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record11<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList11.asNotMaterialized
(ResultQuery<R> query) Specify a non-materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record12<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList12.asNotMaterialized
(ResultQuery<R> query) Specify a non-materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record13<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList13.asNotMaterialized
(ResultQuery<R> query) Specify a non-materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record14<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList14.asNotMaterialized
(ResultQuery<R> query) Specify a non-materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record15<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList15.asNotMaterialized
(ResultQuery<R> query) Specify a non-materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record16<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList16.asNotMaterialized
(ResultQuery<R> query) Specify a non-materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record17<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList17.asNotMaterialized
(ResultQuery<R> query) Specify a non-materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record18<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList18.asNotMaterialized
(ResultQuery<R> query) Specify a non-materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record19<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList19.asNotMaterialized
(ResultQuery<R> query) Specify a non-materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record2<?,
?>>
@NotNull CommonTableExpression<R> DerivedColumnList2.asNotMaterialized
(ResultQuery<R> query) Specify a non-materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record20<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList20.asNotMaterialized
(ResultQuery<R> query) Specify a non-materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record21<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList21.asNotMaterialized
(ResultQuery<R> query) Specify a non-materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record22<?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList22.asNotMaterialized
(ResultQuery<R> query) Specify a non-materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record3<?,
?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList3.asNotMaterialized
(ResultQuery<R> query) Specify a non-materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record4<?,
?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList4.asNotMaterialized
(ResultQuery<R> query) Specify a non-materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record5<?,
?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList5.asNotMaterialized
(ResultQuery<R> query) Specify a non-materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record6<?,
?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList6.asNotMaterialized
(ResultQuery<R> query) Specify a non-materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record7<?,
?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList7.asNotMaterialized
(ResultQuery<R> query) Specify a non-materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record8<?,
?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList8.asNotMaterialized
(ResultQuery<R> query) Specify a non-materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record9<?,
?, ?, ?, ?, ?, ?, ?, ?>>
@NotNull CommonTableExpression<R> DerivedColumnList9.asNotMaterialized
(ResultQuery<R> query) Specify a non-materialized subselect to refer to by theDerivedColumnList
to form a common table expression.<R extends Record>
@NotNull CommonTableExpression<R> Name.asNotMaterialized
(ResultQuery<R> query) Specify a non-materialized subselect to refer to by theName
to form a common table expression.@NotNull WithStep
WithAsStep.asNotMaterialized
(ResultQuery<?> query) Associate a materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep1.asNotMaterialized
(ResultQuery<? extends Record1<?>> query) Associate a non-materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep10.asNotMaterialized
(ResultQuery<? extends Record10<?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a non-materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep11.asNotMaterialized
(ResultQuery<? extends Record11<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a non-materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep12.asNotMaterialized
(ResultQuery<? extends Record12<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a non-materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep13.asNotMaterialized
(ResultQuery<? extends Record13<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a non-materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep14.asNotMaterialized
(ResultQuery<? extends Record14<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a non-materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep15.asNotMaterialized
(ResultQuery<? extends Record15<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a non-materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep16.asNotMaterialized
(ResultQuery<? extends Record16<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a non-materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep17.asNotMaterialized
(ResultQuery<? extends Record17<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a non-materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep18.asNotMaterialized
(ResultQuery<? extends Record18<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a non-materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep19.asNotMaterialized
(ResultQuery<? extends Record19<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a non-materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep2.asNotMaterialized
(ResultQuery<? extends Record2<?, ?>> query) Associate a non-materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep20.asNotMaterialized
(ResultQuery<? extends Record20<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a non-materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep21.asNotMaterialized
(ResultQuery<? extends Record21<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a non-materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep22.asNotMaterialized
(ResultQuery<? extends Record22<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a non-materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep3.asNotMaterialized
(ResultQuery<? extends Record3<?, ?, ?>> query) Associate a non-materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep4.asNotMaterialized
(ResultQuery<? extends Record4<?, ?, ?, ?>> query) Associate a non-materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep5.asNotMaterialized
(ResultQuery<? extends Record5<?, ?, ?, ?, ?>> query) Associate a non-materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep6.asNotMaterialized
(ResultQuery<? extends Record6<?, ?, ?, ?, ?, ?>> query) Associate a non-materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep7.asNotMaterialized
(ResultQuery<? extends Record7<?, ?, ?, ?, ?, ?, ?>> query) Associate a non-materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep8.asNotMaterialized
(ResultQuery<? extends Record8<?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a non-materialized subselect with a common table expression's table and column names.@NotNull WithStep
WithAsStep9.asNotMaterialized
(ResultQuery<? extends Record9<?, ?, ?, ?, ?, ?, ?, ?, ?>> query) Associate a non-materialized subselect with a common table expression's table and column names.DSLContext.fetch
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return results.<R extends Record>
@NotNull CompletionStage<Result<R>> DSLContext.fetchAsync
(Executor executor, ResultQuery<R> query) Fetch results in a newCompletionStage
that is asynchronously completed by a task running in the given executor.<R extends Record>
@NotNull CompletionStage<Result<R>> DSLContext.fetchAsync
(ResultQuery<R> query) Fetch results in a newCompletionStage
.DSLContext.fetchGroups
(ResultQuery<? extends Record2<K, V>> query) Execute the query and return aMap
with the first column as the map key and the second column as the map values.DSLContext.fetchLazy
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return a cursor.DSLContext.fetchMany
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return a cursor.<K,
V> @NotNull Map <K, V> DSLContext.fetchMap
(ResultQuery<? extends Record2<K, V>> query) Execute the query and return aMap
with the first column as the map key and the second column as the map value.<R extends Record>
RDSLContext.fetchOne
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return a record.DSLContext.fetchOptional
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return a record.DSLContext.fetchOptionalValue
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return a single value.<R extends Record>
RDSLContext.fetchSingle
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return a record.DSLContext.fetchStream
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return a stream.<T,
R extends Record1<T>>
TDSLContext.fetchValue
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return a single value.DSLContext.fetchValues
(ResultQuery<R> query) Execute aResultQuery
in the context of thisDSLContext
and return all values for the only column. -
Uses of ResultQuery in org.jooq.impl
Modifier and TypeInterfaceDescriptionstatic interface
QOM.DeleteReturning<R extends Record>
AnDELETE
statement with aRETURNING
clause.static interface
QOM.InsertReturning<R extends Record>
AnINSERT
statement with aRETURNING
clause.static interface
QOM.UpdateReturning<R extends Record>
AnUPDATE
statement with aRETURNING
clause.Modifier and TypeMethodDescription@Nullable ResultQuery
<? extends R> QOM.CreateView.$query()
DefaultDSLContext.resultQuery
(String sql) DefaultDSLContext.resultQuery
(String sql, Object... bindings) DefaultDSLContext.resultQuery
(String sql, QueryPart... parts) DefaultDSLContext.resultQuery
(SQL sql) static @NotNull ResultQuery
<Record> DSL.resultQuery
(String sql) Create a new query holding plain SQL.static @NotNull ResultQuery
<Record> DSL.resultQuery
(String sql, Object... bindings) Create a new query holding plain SQL.static @NotNull ResultQuery
<Record> DSL.resultQuery
(String sql, QueryPart... parts) Create a new query holding plain SQL.static @NotNull ResultQuery
<Record> DSL.resultQuery
(SQL sql) Create a new query holding plain SQL.Modifier and TypeMethodDescription@NotNull QOM.CreateView
<R> QOM.CreateView.$query
(ResultQuery<? extends R> query) DefaultDSLContext.fetch
(ResultQuery<R> query) <R extends Record>
CompletionStage<Result<R>> DefaultDSLContext.fetchAsync
(Executor executor, ResultQuery<R> query) <R extends Record>
CompletionStage<Result<R>> DefaultDSLContext.fetchAsync
(ResultQuery<R> query) DefaultDSLContext.fetchGroups
(ResultQuery<? extends Record2<K, V>> query) DefaultDSLContext.fetchLazy
(ResultQuery<R> query) DefaultDSLContext.fetchMany
(ResultQuery<R> query) <K,
V> Map <K, V> DefaultDSLContext.fetchMap
(ResultQuery<? extends Record2<K, V>> query) <R extends Record>
RDefaultDSLContext.fetchOne
(ResultQuery<R> query) DefaultDSLContext.fetchOptional
(ResultQuery<R> query) DefaultDSLContext.fetchOptionalValue
(ResultQuery<R> query) <R extends Record>
RDefaultDSLContext.fetchSingle
(ResultQuery<R> query) DefaultDSLContext.fetchStream
(ResultQuery<R> query) <T,
R extends Record1<T>>
TDefaultDSLContext.fetchValue
(ResultQuery<R> query) DefaultDSLContext.fetchValues
(ResultQuery<R> query)