Uses of Interface
org.jooq.ResultQuery

Packages that use ResultQuery
Package
Description
This package contains jOOQ's public API.
This package contains jOOQ's implementation classes.
  • Uses of ResultQuery in org.jooq

    Subinterfaces of ResultQuery in org.jooq
    Modifier and Type
    Interface
    Description
    interface 
    This type is used for the Delete's DSL API.
    interface 
    This type is used for the Insert's DSL API.
    interface 
    Select<R extends Record>
    A SELECT statement.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    SelectQuery<R extends Record>
    A SELECT statement (model API).
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    SelectSeekStep1<R extends Record,​T1>
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    SelectSeekStep10<R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10>
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    SelectSeekStep11<R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11>
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    SelectSeekStep12<R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12>
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    SelectSeekStep13<R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13>
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    SelectSeekStep14<R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14>
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    SelectSeekStep15<R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15>
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    SelectSeekStep16<R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16>
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    SelectSeekStep17<R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17>
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    SelectSeekStep18<R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18>
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    SelectSeekStep19<R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10,​T11,​T12,​T13,​T14,​T15,​T16,​T17,​T18,​T19>
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    SelectSeekStep2<R extends Record,​T1,​T2>
    This type is used for the Select's DSL API when selecting generic Record types.
    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>
    This type is used for the Select's DSL API when selecting generic Record types.
    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>
    This type is used for the Select's DSL API when selecting generic Record types.
    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>
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    SelectSeekStep3<R extends Record,​T1,​T2,​T3>
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    SelectSeekStep4<R extends Record,​T1,​T2,​T3,​T4>
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    SelectSeekStep5<R extends Record,​T1,​T2,​T3,​T4,​T5>
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    SelectSeekStep6<R extends Record,​T1,​T2,​T3,​T4,​T5,​T6>
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    SelectSeekStep7<R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7>
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    SelectSeekStep8<R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8>
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    SelectSeekStep9<R extends Record,​T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9>
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Select's DSL API when selecting generic Record types.
    interface 
    This type is used for the Update's DSL API.
    Methods in org.jooq that return ResultQuery
    Modifier and Type
    Method
    Description
    @NotNull ResultQuery<R>
    ResultQuery.bind​(int index, Object value)
     
    @NotNull ResultQuery<R>
    ResultQuery.bind​(String param, Object value)
     
    ResultQuery.coerce​(Collection<? extends Field<?>> fields)
    Coerce the result record type of this query to that of a set of fields.
    ResultQuery.coerce​(Field<?>... fields)
    Coerce the result record type of this query to that of a set of fields.
    <T1> @NotNull ResultQuery<Record1<T1>>
    ResultQuery.coerce​(Field<T1> field1)
    Coerce the result record type of this query to that of a set of fields.
    <T1,​ T2> @NotNull ResultQuery<Record2<T1,​T2>>
    ResultQuery.coerce​(Field<T1> field1, Field<T2> field2)
    Coerce the result record type of this query to that of a set of fields.
    <T1,​ T2,​ T3> @NotNull ResultQuery<Record3<T1,​T2,​T3>>
    ResultQuery.coerce​(Field<T1> field1, Field<T2> field2, Field<T3> field3)
    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>>
    ResultQuery.coerce​(Field<T1> field1, Field<T2> field2, Field<T3> field3, Field<T4> field4)
    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>
    ResultQuery.coerce​(Table<X> table)
    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 underlying Statement.
    @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>
    ResultQuery.intern​(String... fieldNames)
    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.intern​(Field<?>... fields)
    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.intern​(Name... fieldNames)
    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 underlying Statement.
    @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)
     
    DSLContext.resultQuery​(String sql)
    Create a new query holding plain SQL.
    DSLContext.resultQuery​(String sql, Object... bindings)
    Create a new query holding plain SQL.
    DSLContext.resultQuery​(String sql, QueryPart... parts)
    Create a new query holding plain SQL.
    DSLContext.resultQuery​(SQL sql)
    Create a new query holding plain SQL.
    @NotNull ResultQuery<R>
    ResultQuery.resultSetConcurrency​(int resultSetConcurrency)
    Specify the ResultSet concurrency of ResultSet objects created by jOOQ.
    @NotNull ResultQuery<R>
    ResultQuery.resultSetHoldability​(int resultSetHoldability)
    Specify the ResultSet holdability of ResultSet objects created by jOOQ.
    @NotNull ResultQuery<R>
    ResultQuery.resultSetType​(int resultSetType)
    Specify the ResultSet type of ResultSet objects created by jOOQ.
    Methods in org.jooq with parameters of type ResultQuery
    Modifier and Type
    Method
    Description
    <R extends Record>
    @NotNull CommonTableExpression<R>
    DerivedColumnList.as​(ResultQuery<R> query)
    Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
    <R extends Record1<?>>
    @NotNull CommonTableExpression<R>
    DerivedColumnList1.as​(ResultQuery<R> query)
    Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
    <R extends Record10<?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?>>
    @NotNull CommonTableExpression<R>
    DerivedColumnList10.as​(ResultQuery<R> query)
    Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
    <R extends Record11<?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?>>
    @NotNull CommonTableExpression<R>
    DerivedColumnList11.as​(ResultQuery<R> query)
    Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
    <R extends Record12<?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?>>
    @NotNull CommonTableExpression<R>
    DerivedColumnList12.as​(ResultQuery<R> query)
    Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
    <R extends Record13<?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?>>
    @NotNull CommonTableExpression<R>
    DerivedColumnList13.as​(ResultQuery<R> query)
    Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
    <R extends Record14<?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?>>
    @NotNull CommonTableExpression<R>
    DerivedColumnList14.as​(ResultQuery<R> query)
    Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
    <R extends Record15<?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?>>
    @NotNull CommonTableExpression<R>
    DerivedColumnList15.as​(ResultQuery<R> query)
    Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
    <R extends Record16<?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?>>
    @NotNull CommonTableExpression<R>
    DerivedColumnList16.as​(ResultQuery<R> query)
    Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
    <R extends Record17<?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?>>
    @NotNull CommonTableExpression<R>
    DerivedColumnList17.as​(ResultQuery<R> query)
    Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
    <R extends Record18<?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?>>
    @NotNull CommonTableExpression<R>
    DerivedColumnList18.as​(ResultQuery<R> query)
    Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
    <R extends Record19<?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?>>
    @NotNull CommonTableExpression<R>
    DerivedColumnList19.as​(ResultQuery<R> query)
    Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
    <R extends Record2<?,​ ?>>
    @NotNull CommonTableExpression<R>
    DerivedColumnList2.as​(ResultQuery<R> query)
    Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
    <R extends Record20<?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?>>
    @NotNull CommonTableExpression<R>
    DerivedColumnList20.as​(ResultQuery<R> query)
    Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
    <R extends Record21<?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?>>
    @NotNull CommonTableExpression<R>
    DerivedColumnList21.as​(ResultQuery<R> query)
    Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
    <R extends Record22<?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?>>
    @NotNull CommonTableExpression<R>
    DerivedColumnList22.as​(ResultQuery<R> query)
    Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
    <R extends Record3<?,​ ?,​ ?>>
    @NotNull CommonTableExpression<R>
    DerivedColumnList3.as​(ResultQuery<R> query)
    Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
    <R extends Record4<?,​ ?,​ ?,​ ?>>
    @NotNull CommonTableExpression<R>
    DerivedColumnList4.as​(ResultQuery<R> query)
    Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
    <R extends Record5<?,​ ?,​ ?,​ ?,​ ?>>
    @NotNull CommonTableExpression<R>
    DerivedColumnList5.as​(ResultQuery<R> query)
    Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
    <R extends Record6<?,​ ?,​ ?,​ ?,​ ?,​ ?>>
    @NotNull CommonTableExpression<R>
    DerivedColumnList6.as​(ResultQuery<R> query)
    Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
    <R extends Record7<?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?>>
    @NotNull CommonTableExpression<R>
    DerivedColumnList7.as​(ResultQuery<R> query)
    Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
    <R extends Record8<?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?>>
    @NotNull CommonTableExpression<R>
    DerivedColumnList8.as​(ResultQuery<R> query)
    Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
    <R extends Record9<?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?,​ ?>>
    @NotNull CommonTableExpression<R>
    DerivedColumnList9.as​(ResultQuery<R> query)
    Specify a subselect to refer to by the DerivedColumnList to form a common table expression.
    <R extends Record>
    @NotNull CommonTableExpression<R>
    Name.as​(ResultQuery<R> query)
    Specify a subselect to refer to by the Name 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the Name 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the DerivedColumnList 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 the Name 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.
    <R extends Record>
    @NotNull Result<R>
    DSLContext.fetch​(ResultQuery<R> query)
    Execute a ResultQuery in the context of this DSLContext and return results.
    <R extends Record>
    @NotNull CompletionStage<Result<R>>
    DSLContext.fetchAsync​(Executor executor, ResultQuery<R> query)
    Fetch results in a new CompletionStage 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 new CompletionStage.
    <R extends Record>
    @NotNull Cursor<R>
    DSLContext.fetchLazy​(ResultQuery<R> query)
    Execute a ResultQuery in the context of this DSLContext and return a cursor.
    <R extends Record>
    @NotNull Results
    DSLContext.fetchMany​(ResultQuery<R> query)
    Execute a ResultQuery in the context of this DSLContext and return a cursor.
    <R extends Record>
    R
    DSLContext.fetchOne​(ResultQuery<R> query)
    Execute a ResultQuery in the context of this DSLContext and return a record.
    <R extends Record>
    @NotNull Optional<R>
    DSLContext.fetchOptional​(ResultQuery<R> query)
    Execute a ResultQuery in the context of this DSLContext and return a record.
    <T,​ R extends Record1<T>>
    @NotNull Optional<T>
    DSLContext.fetchOptionalValue​(ResultQuery<R> query)
    Execute a ResultQuery in the context of this DSLContext and return a single value.
    <R extends Record>
    R
    DSLContext.fetchSingle​(ResultQuery<R> query)
    Execute a ResultQuery in the context of this DSLContext and return a record.
    <R extends Record>
    @NotNull Stream<R>
    DSLContext.fetchStream​(ResultQuery<R> query)
    Execute a ResultQuery in the context of this DSLContext and return a stream.
    <T,​ R extends Record1<T>>
    T
    DSLContext.fetchValue​(ResultQuery<R> query)
    Execute a ResultQuery in the context of this DSLContext and return a single value.
    <T,​ R extends Record1<T>>
    @NotNull List<T>
    DSLContext.fetchValues​(ResultQuery<R> query)
    Execute a ResultQuery in the context of this DSLContext and return all values for the only column.
  • Uses of ResultQuery in org.jooq.impl

    Methods in org.jooq.impl that return ResultQuery
    Modifier and Type
    Method
    Description
    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.
    Methods in org.jooq.impl with parameters of type ResultQuery
    Modifier and Type
    Method
    Description
    <R extends Record>
    Result<R>
    DefaultDSLContext.fetch​(ResultQuery<R> query)
     
    DefaultDSLContext.fetchAsync​(Executor executor, ResultQuery<R> query)
     
    DefaultDSLContext.fetchAsync​(ResultQuery<R> query)
     
    <R extends Record>
    Cursor<R>
    DefaultDSLContext.fetchLazy​(ResultQuery<R> query)
     
    <R extends Record>
    Results
    DefaultDSLContext.fetchMany​(ResultQuery<R> query)
     
    <R extends Record>
    R
    DefaultDSLContext.fetchOne​(ResultQuery<R> query)
     
    <R extends Record>
    Optional<R>
    DefaultDSLContext.fetchOptional​(ResultQuery<R> query)
     
    <T,​ R extends Record1<T>>
    Optional<T>
    DefaultDSLContext.fetchOptionalValue​(ResultQuery<R> query)
     
    <R extends Record>
    R
    DefaultDSLContext.fetchSingle​(ResultQuery<R> query)
     
    <R extends Record>
    Stream<R>
    DefaultDSLContext.fetchStream​(ResultQuery<R> query)
     
    <T,​ R extends Record1<T>>
    T
    DefaultDSLContext.fetchValue​(ResultQuery<R> query)
     
    <T,​ R extends Record1<T>>
    List<T>
    DefaultDSLContext.fetchValues​(ResultQuery<R> query)