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
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>
@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.keepStatement(boolean keepStatement)
@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<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.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.<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 TypeMethodDescriptionDefaultDSLContext.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 TypeMethodDescriptionDefaultDSLContext.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.fetchLazy(ResultQuery<R> query)
DefaultDSLContext.fetchMany(ResultQuery<R> 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)