All Superinterfaces:: FieldOrRow, Fields, Named, QueryPart, Row, SelectField<Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>>, SelectFieldOrAsterisk, Serializable, Typed<Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>>

public interface Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> extends Row, SelectField<Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>>

A row value expression.

Row value expressions are mainly useful for use in predicates, when comparing several values in one go, which can be more elegant than expanding the row value expression predicate in other equivalent syntaxes. This is especially true for non-equality predicates. For instance, the following two predicates are equivalent in SQL:

 (A, B) > (X, Y)
 (A > X) OR (A = X AND B > Y)

Example:

 // Assuming import static org.jooq.impl.DSL.*;

 using(configuration)
    .select()
    .from(CUSTOMER)
    .where(row(CUSTOMER.FIRST_NAME, CUSTOMER.LAST_NAME).in(
        select(ACTOR.FIRST_NAME, ACTOR.LAST_NAME).from(ACTOR)
    ))
    .fetch();

Note: Not all databases support row value expressions, but many row value expression operations can be emulated on all databases. See relevant row value expression method Javadocs for details.

Instances can be created using DSL.row(Object...) and overloads.

Author:: Lukas Eder

Method Summary

Modifier and Type

Method

Description

@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>

between(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7, Field<T8> minValue8, Field<T9> minValue9, Field<T10> minValue10)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>

between(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue)

Check if this row value expression is within a range of two records.

@NotNull Condition

between(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue, Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> maxValue)

Check if this row value expression is within a range of two records.

@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>

between(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull Condition

between(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue, Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> maxValue)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>

between(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10)

Check if this row value expression is within a range of two other row value expressions.

@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>

betweenSymmetric(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7, Field<T8> minValue8, Field<T9> minValue9, Field<T10> minValue10)

Check if this row value expression is within a symmetric range of two other row value expressions.

@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>

betweenSymmetric(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue)

Check if this row value expression is within a symmetric range of two records.

@NotNull Condition

betweenSymmetric(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue, Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> maxValue)

Check if this row value expression is within a symmetric range of two records.

@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>

betweenSymmetric(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue)

Check if this row value expression is within a symmetric range of two other row value expressions.

@NotNull Condition

betweenSymmetric(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue, Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> maxValue)

Check if this row value expression is within a symmetric range of two other row value expressions.

@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>

betweenSymmetric(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10)

Check if this row value expression is within a symmetric range of two other row value expressions.

@NotNull Condition

compare(Comparator comparator, Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10)

Compare this row value expression with another row value expression using a dynamic comparator.

@NotNull Condition

compare(Comparator comparator, QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)

Compare this row value expression with a subselect using a dynamic comparator.

@NotNull Condition

compare(Comparator comparator, Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)

Compare this row value expression with a record using a dynamic comparator.

@NotNull Condition

compare(Comparator comparator, Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)

Compare this row value expression with another row value expression using a dynamic comparator.

@NotNull Condition

compare(Comparator comparator, Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)

Compare this row value expression with a subselect using a dynamic comparator.

@NotNull Condition

compare(Comparator comparator, T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)

Compare this row value expression with another row value expression using a dynamic comparator.

@NotNull Condition

eq(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

eq(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)

Compare this row value expression with a subselect for equality.

@NotNull Condition

eq(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)

Compare this row value expression with a record for equality.

@NotNull Condition

eq(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

eq(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)

Compare this row value expression with a subselect for equality.

@NotNull Condition

eq(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

equal(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

equal(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)

Compare this row value expression with a subselect for equality.

@NotNull Condition

equal(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)

Compare this row value expression with a record for equality.

@NotNull Condition

equal(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)

Compare this row value expression with another row value expression for equality.

@NotNull Condition

equal(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)

Compare this row value expression with a subselect for equality.

@NotNull Condition

equal(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)

Compare this row value expression with another row value expression for equality.

@NotNull Field<T1>

field1()

Get the first field.

@NotNull Field<T10>

field10()

Get the tenth field.

@NotNull Field<T2>

field2()

Get the second field.

@NotNull Field<T3>

field3()

Get the third field.

@NotNull Field<T4>

field4()

Get the fourth field.

@NotNull Field<T5>

field5()

Get the fifth field.

@NotNull Field<T6>

field6()

Get the sixth field.

@NotNull Field<T7>

field7()

Get the seventh field.

@NotNull Field<T8>

field8()

Get the eighth field.

@NotNull Field<T9>

field9()

Get the ninth field.

@NotNull Condition

ge(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10)

Compare this row value expression with another row value expression for order.

@NotNull Condition

ge(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)

Compare this row value expression with a subselect for order.

@NotNull Condition

ge(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)

Compare this row value expression with a record for order.

@NotNull Condition

ge(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)

Compare this row value expression with another row value expression for order.

@NotNull Condition

ge(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)

Compare this row value expression with a subselect for order.

@NotNull Condition

ge(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)

Compare this row value expression with another row value expression for order.

@NotNull Condition

greaterOrEqual(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10)

Compare this row value expression with another row value expression for order.

@NotNull Condition

greaterOrEqual(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)

Compare this row value expression with a subselect for order.

@NotNull Condition

greaterOrEqual(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)

Compare this row value expression with a record for order.

@NotNull Condition

greaterOrEqual(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)

Compare this row value expression with another row value expression for order.

@NotNull Condition

greaterOrEqual(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)

Compare this row value expression with a subselect for order.

@NotNull Condition

greaterOrEqual(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)

Compare this row value expression with another row value expression for order.

@NotNull Condition

greaterThan(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10)

Compare this row value expression with another row value expression for order.

@NotNull Condition

greaterThan(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)

Compare this row value expression with a subselect for order.

@NotNull Condition

greaterThan(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)

Compare this row value expression with a record for order.

@NotNull Condition

greaterThan(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)

Compare this row value expression with another row value expression for order.

@NotNull Condition

greaterThan(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)

Compare this row value expression with a subselect for order.

@NotNull Condition

greaterThan(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)

Compare this row value expression with another row value expression for order.

@NotNull Condition

gt(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10)

Compare this row value expression with another row value expression for order.

@NotNull Condition

gt(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)

Compare this row value expression with a subselect for order.

@NotNull Condition

gt(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)

Compare this row value expression with a record for order.

@NotNull Condition

gt(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)

Compare this row value expression with another row value expression for order.

@NotNull Condition

gt(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)

Compare this row value expression with a subselect for order.

@NotNull Condition

gt(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)

Compare this row value expression with another row value expression for order.

@NotNull Condition

in(Collection<? extends Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> rows)

Compare this row value expression with a set of row value expressions for equality.

@NotNull Condition

in(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>... record)

Compare this row value expression with a set of records for equality.

@NotNull Condition

in(Result<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> result)

Compare this row value expression with a set of records for equality.

@NotNull Condition

in(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>... rows)

Compare this row value expression with a set of row value expressions for equality.

@NotNull Condition

in(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)

Compare this row value expression with a subselect for equality.

@NotNull Condition

isDistinctFrom(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10)

Compare this row value expression with another row value expression for distinctness.

@NotNull Condition

isDistinctFrom(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)

Compare this row value expression with another row value expression for distinctness.

@NotNull Condition

isDistinctFrom(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)

Compare this row value expression with another row value expression for distinctness.

@NotNull Condition

isDistinctFrom(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)

Compare this row value expression with another row value expression for distinctness.

@NotNull Condition

isDistinctFrom(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)

Compare this row value expression with another row value expression for distinctness.

@NotNull Condition

isNotDistinctFrom(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10)

Compare this row value expression with another row value expression for distinctness.

@NotNull Condition

isNotDistinctFrom(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)

Compare this row value expression with another row value expression for distinctness.

@NotNull Condition

isNotDistinctFrom(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)

Compare this row value expression with another row value expression for distinctness.

@NotNull Condition

isNotDistinctFrom(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)

Compare this row value expression with another row value expression for distinctness.

@NotNull Condition

isNotDistinctFrom(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)

Compare this row value expression with another row value expression for distinctness.

@NotNull Condition

le(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10)

Compare this row value expression with another row value expression for order.

@NotNull Condition

le(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)

Compare this row value expression with a subselect for order.

@NotNull Condition

le(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)

Compare this row value expression with a record for order.

@NotNull Condition

le(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)

Compare this row value expression with another row value expression for order.

@NotNull Condition

le(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)

Compare this row value expression with a subselect for order.

@NotNull Condition

le(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)

Compare this row value expression with another row value expression for order.

@NotNull Condition

lessOrEqual(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10)

Compare this row value expression with another row value expression for order.

@NotNull Condition

lessOrEqual(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)

Compare this row value expression with a subselect for order.

@NotNull Condition

lessOrEqual(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)

Compare this row value expression with a record for order.

@NotNull Condition

lessOrEqual(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)

Compare this row value expression with another row value expression for order.

@NotNull Condition

lessOrEqual(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)

Compare this row value expression with a subselect for order.

@NotNull Condition

lessOrEqual(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)

Compare this row value expression with another row value expression for order.

@NotNull Condition

lessThan(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10)

Compare this row value expression with another row value expression for order.

@NotNull Condition

lessThan(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)

Compare this row value expression with a subselect for order.

@NotNull Condition

lessThan(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)

Compare this row value expression with a record for order.

@NotNull Condition

lessThan(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)

Compare this row value expression with another row value expression for order.

@NotNull Condition

lessThan(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)

Compare this row value expression with a subselect for order.

@NotNull Condition

lessThan(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)

Compare this row value expression with another row value expression for order.

@NotNull Condition

lt(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10)

Compare this row value expression with another row value expression for order.

@NotNull Condition

lt(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)

Compare this row value expression with a subselect for order.

@NotNull Condition

lt(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)

Compare this row value expression with a record for order.

@NotNull Condition

lt(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)

Compare this row value expression with another row value expression for order.

@NotNull Condition

lt(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)

Compare this row value expression with a subselect for order.

@NotNull Condition

lt(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)

Compare this row value expression with another row value expression for order.

 @NotNull SelectField

mapping(Class uType, Function10<? super T1,? super T2,? super T3,? super T4,? super T5,? super T6,? super T7,? super T8,? super T9,? super T10,? extends U> function)

A convenience method to define a local Record10 to custom type RecordMapper that can be used when projecting Row types in SELECT or RETURNING clauses.

 @NotNull SelectField

mapping(Function10<? super T1,? super T2,? super T3,? super T4,? super T5,? super T6,? super T7,? super T8,? super T9,? super T10,? extends U> function)

A convenience method to define a local Record10 to custom type RecordMapper that can be used when projecting Row types in SELECT or RETURNING clauses.

@NotNull Condition

ne(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10)

Compare this row value expression with another row value expression for non-equality.

@NotNull Condition

ne(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)

Compare this row value expression with a subselect for non-equality.

@NotNull Condition

ne(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)

Compare this row value expression with a record for non-equality.

@NotNull Condition

ne(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)

Compare this row value expression with another row value expression for non-equality.

@NotNull Condition

ne(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)

Compare this row value expression with a subselect for non-equality.

@NotNull Condition

ne(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)

Compare this row value expression with another row value expression for non-equality.

@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>

notBetween(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7, Field<T8> minValue8, Field<T9> minValue9, Field<T10> minValue10)

Check if this row value expression is not within a range of two other row value expressions.

@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>

notBetween(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue)

Check if this row value expression is within a range of two records.

@NotNull Condition

notBetween(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue, Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> maxValue)

Check if this row value expression is within a range of two records.

@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>

notBetween(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue)

Check if this row value expression is not within a range of two other row value expressions.

@NotNull Condition

notBetween(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue, Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> maxValue)

Check if this row value expression is not within a range of two other row value expressions.

@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>

notBetween(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10)

Check if this row value expression is not within a range of two other row value expressions.

@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>

notBetweenSymmetric(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7, Field<T8> minValue8, Field<T9> minValue9, Field<T10> minValue10)

Check if this row value expression is not within a symmetric range of two other row value expressions.

@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>

notBetweenSymmetric(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue)

Check if this row value expression is not within a symmetric range of two records.

@NotNull Condition

notBetweenSymmetric(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue, Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> maxValue)

Check if this row value expression is not within a symmetric range of two records.

@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>

notBetweenSymmetric(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue)

Check if this row value expression is not within a symmetric range of two other row value expressions.

@NotNull Condition

notBetweenSymmetric(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue, Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> maxValue)

Check if this row value expression is not within a symmetric range of two other row value expressions.

@NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>

notBetweenSymmetric(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10)

Check if this row value expression is not within a symmetric range of two other row value expressions.

@NotNull Condition

notEqual(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10)

Compare this row value expression with another row value expression for non-equality.

@NotNull Condition

notEqual(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)

Compare this row value expression with a subselect for non-equality.

@NotNull Condition

notEqual(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)

Compare this row value expression with a record for non-equality

@NotNull Condition

notEqual(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)

Compare this row value expression with another row value expression for non-equality.

@NotNull Condition

notEqual(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)

Compare this row value expression with a subselect for non-equality.

@NotNull Condition

notEqual(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)

Compare this row value expression with another row value expression for.

@NotNull Condition

notIn(Collection<? extends Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> rows)

Compare this row value expression with a set of row value expressions for equality.

@NotNull Condition

notIn(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>... record)

Compare this row value expression with a set of records for non-equality.

@NotNull Condition

notIn(Result<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> result)

Compare this row value expression with a set of records for equality.

@NotNull Condition

notIn(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>... rows)

Compare this row value expression with a set of row value expressions for equality.

@NotNull Condition

notIn(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)

Compare this row value expression with a subselect for non-equality.

@NotNull Statement

set(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10)

Assign a value to this set of variables.

@NotNull Statement

set(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)

Assign a value to this set of variables.

@NotNull Statement

set(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)

Assign a value to this set of variables.

@NotNull Statement

set(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> value)

Assign a value to this set of variables.

@NotNull Statement

set(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)

Assign a value to this set of variables.

Methods inherited from interface org.jooq.Fields
dataType, dataType, dataType, dataTypes, field, field, field, field, field, field, field, field, field, field, fields, fields, fields, fields, fields, fieldsRow, fieldStream, indexOf, indexOf, indexOf, type, type, type, types

Methods inherited from interface org.jooq.Named
getComment, getCommentPart, getName, getQualifiedName, getUnqualifiedName

Methods inherited from interface org.jooq.QueryPart
equals, hashCode, toString

Methods inherited from interface org.jooq.Row
isNotNull, isNull, size

Methods inherited from interface org.jooq.SelectField
as, as, as

Methods inherited from interface org.jooq.Typed
getBinding, getConverter, getDataType, getDataType, getType

Method Details
- mapping
 
 @NotNull @Internal @NotNull SelectField mapping(Function10<? super T1,? super T2,? super T3,? super T4,? super T5,? super T6,? super T7,? super T8,? super T9,? super T10,? extends U> function)
 A convenience method to define a local Record10 to custom type RecordMapper that can be used when projecting Row types in SELECT or RETURNING clauses.
 EXPERIMENTAL. Unlike mapping(Class, Function10), this method attempts to work without an explicit Class reference for the underlying Converter.toType(). There may be some edge cases where this doesn't work. Please report any bugs here: https://github.com/jOOQ/jOOQ/issues/new/choose
 Known issues include:
 
 When nesting rows in arrays, the class literal is required for reflective array creation.
- mapping
 
 @NotNull @NotNull SelectField mapping(Class uType, Function10<? super T1,? super T2,? super T3,? super T4,? super T5,? super T6,? super T7,? super T8,? super T9,? super T10,? extends U> function)
 
 A convenience method to define a local Record10 to custom type RecordMapper that can be used when projecting Row types in SELECT or RETURNING clauses.
- field1
 
 @NotNull @NotNull Field<T1> field1()
 
 Get the first field.
- field2
 
 @NotNull @NotNull Field<T2> field2()
 
 Get the second field.
- field3
 
 @NotNull @NotNull Field<T3> field3()
 
 Get the third field.
- field4
 
 @NotNull @NotNull Field<T4> field4()
 
 Get the fourth field.
- field5
 
 @NotNull @NotNull Field<T5> field5()
 
 Get the fifth field.
- field6
 
 @NotNull @NotNull Field<T6> field6()
 
 Get the sixth field.
- field7
 
 @NotNull @NotNull Field<T7> field7()
 
 Get the seventh field.
- field8
 
 @NotNull @NotNull Field<T8> field8()
 
 Get the eighth field.
- field9
 
 @NotNull @NotNull Field<T9> field9()
 
 Get the ninth field.
- field10
 
 @NotNull @NotNull Field<T10> field10()
 
 Get the tenth field.
- compare
 
 @NotNull @Support @NotNull Condition compare(Comparator comparator, Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
 
 Compare this row value expression with another row value expression using a dynamic comparator.
 See the explicit comparison methods for details. Note, not all Comparator types are supported
 
 See Also:
 
 equal(Row10), notEqual(Row10), lessThan(Row10), lessOrEqual(Row10), greaterThan(Row10), greaterOrEqual(Row10)
- compare
 
 @NotNull @Support @NotNull Condition compare(Comparator comparator, Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
 
 Compare this row value expression with a record using a dynamic comparator.
 See the explicit comparison methods for details. Note, not all Comparator types are supported
 
 See Also:
 
 equal(Record10), notEqual(Record10), lessThan(Record10), lessOrEqual(Record10), greaterThan(Record10), greaterOrEqual(Record10)
- compare
 
 @NotNull @Support @NotNull Condition compare(Comparator comparator, T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)
 
 Compare this row value expression with another row value expression using a dynamic comparator.
 See the explicit comparison methods for details. Note, not all Comparator types are supported
 
 See Also:
 
 equal(Row10), notEqual(Row10), lessThan(Row10), lessOrEqual(Row10), greaterThan(Row10), greaterOrEqual(Row10)
- compare
 
 @NotNull @Support @NotNull Condition compare(Comparator comparator, Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10)
 
 Compare this row value expression with another row value expression using a dynamic comparator.
 See the explicit comparison methods for details. Note, not all Comparator types are supported
 
 See Also:
 
 equal(Row10), notEqual(Row10), lessThan(Row10), lessOrEqual(Row10), greaterThan(Row10), greaterOrEqual(Row10)
- compare
 
 @NotNull @Support @NotNull Condition compare(Comparator comparator, Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
 
 Compare this row value expression with a subselect using a dynamic comparator.
 See the explicit comparison methods for details. Note, not all Comparator types are supported
 
 See Also:
 
 equal(Select), notEqual(Select), lessThan(Select), lessOrEqual(Select), greaterThan(Select), greaterOrEqual(Select)
- compare
 
 @NotNull @Support @NotNull Condition compare(Comparator comparator, QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
 
 Compare this row value expression with a subselect using a dynamic comparator.
 See the explicit comparison methods for details. Note, not all Comparator types are supported
 
 See Also:
 
 equal(Select), notEqual(Select), lessThan(Select), lessOrEqual(Select), greaterThan(Select), greaterOrEqual(Select)
- equal
 
 @NotNull @Support @NotNull Condition equal(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
 
 Compare this row value expression with another row value expression for equality.
 Row equality comparison predicates can be emulated in those databases that do not support such predicates natively: (A, B) = (1, 2) is equivalent to A = 1 AND B = 2
- equal
 
 @NotNull @Support @NotNull Condition equal(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
 
 Compare this row value expression with a record for equality.
 
 See Also:
 
 equal(Row10)
- equal
 
 @NotNull @Support @NotNull Condition equal(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)
 
 Compare this row value expression with another row value expression for equality.
 
 See Also:
 
 equal(Row10)
- equal
 
 @NotNull @Support @NotNull Condition equal(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10)
 
 Compare this row value expression with another row value expression for equality.
 
 See Also:
 
 equal(Row10)
- equal
 
 @NotNull @Support @NotNull Condition equal(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
 
 Compare this row value expression with a subselect for equality.
 
 See Also:
 
 equal(Row10)
- equal
 
 @NotNull @Support @NotNull Condition equal(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
 
 Compare this row value expression with a subselect for equality.
 
 See Also:
 
 DSL.all(Field), DSL.all(Select), DSL.all(Object...), DSL.any(Field), DSL.any(Select), DSL.any(Object...)
- eq
 
 @NotNull @Support @NotNull Condition eq(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
 
 Compare this row value expression with another row value expression for equality.
 
 See Also:
 
 equal(Row10)
- eq
 
 @NotNull @Support @NotNull Condition eq(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
 
 Compare this row value expression with a record for equality.
 
 See Also:
 
 equal(Row10)
- eq
 
 @NotNull @Support @NotNull Condition eq(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)
 
 Compare this row value expression with another row value expression for equality.
 
 See Also:
 
 equal(Row10)
- eq
 
 @NotNull @Support @NotNull Condition eq(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10)
 
 Compare this row value expression with another row value expression for equality.
 
 See Also:
 
 equal(Row10)
- eq
 
 @NotNull @Support @NotNull Condition eq(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
 
 Compare this row value expression with a subselect for equality.
 
 See Also:
 
 equal(Row10)
- eq
 
 @NotNull @Support @NotNull Condition eq(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
 
 Compare this row value expression with a subselect for equality.
 
 See Also:
 
 DSL.all(Field), DSL.all(Select), DSL.all(Object...), DSL.any(Field), DSL.any(Select), DSL.any(Object...)
- notEqual
 
 @NotNull @Support @NotNull Condition notEqual(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
 
 Compare this row value expression with another row value expression for non-equality.
 Row non-equality comparison predicates can be emulated in those databases that do not support such predicates natively: (A, B) <> (1, 2) is equivalent to NOT(A = 1 AND B = 2)
- notEqual
 
 @NotNull @Support @NotNull Condition notEqual(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
 
 Compare this row value expression with a record for non-equality
 
 See Also:
 
 notEqual(Row10)
- notEqual
 
 @NotNull @Support @NotNull Condition notEqual(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)
 
 Compare this row value expression with another row value expression for. non-equality
 
 See Also:
 
 notEqual(Row10)
- notEqual
 
 @NotNull @Support @NotNull Condition notEqual(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10)
 
 Compare this row value expression with another row value expression for non-equality.
 
 See Also:
 
 notEqual(Row10)
- notEqual
 
 @NotNull @Support @NotNull Condition notEqual(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
 
 Compare this row value expression with a subselect for non-equality.
 
 See Also:
 
 notEqual(Row10)
- notEqual
 
 @NotNull @Support @NotNull Condition notEqual(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
 
 Compare this row value expression with a subselect for non-equality.
 
 See Also:
 
 DSL.all(Field), DSL.all(Select), DSL.all(Object...), DSL.any(Field), DSL.any(Select), DSL.any(Object...)
- ne
 
 @NotNull @Support @NotNull Condition ne(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
 
 Compare this row value expression with another row value expression for non-equality.
 
 See Also:
 
 notEqual(Row10)
- ne
 
 @NotNull @Support @NotNull Condition ne(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
 
 Compare this row value expression with a record for non-equality.
 
 See Also:
 
 notEqual(Row10)
- ne
 
 @NotNull @Support @NotNull Condition ne(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)
 
 Compare this row value expression with another row value expression for non-equality.
 
 See Also:
 
 notEqual(Row10)
- ne
 
 @NotNull @Support @NotNull Condition ne(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10)
 
 Compare this row value expression with another row value expression for non-equality.
 
 See Also:
 
 notEqual(Row10)
- ne
 
 @NotNull @Support @NotNull Condition ne(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
 
 Compare this row value expression with a subselect for non-equality.
 
 See Also:
 
 notEqual(Row10)
- ne
 
 @NotNull @Support @NotNull Condition ne(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
 
 Compare this row value expression with a subselect for non-equality.
 
 See Also:
 
 DSL.all(Field), DSL.all(Select), DSL.all(Object...), DSL.any(Field), DSL.any(Select), DSL.any(Object...)
- isDistinctFrom
 
 @NotNull @Support @NotNull Condition isDistinctFrom(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
 
 Compare this row value expression with another row value expression for distinctness.
- isDistinctFrom
 
 @NotNull @Support @NotNull Condition isDistinctFrom(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
 
 Compare this row value expression with another row value expression for distinctness.
- isDistinctFrom
 
 @NotNull @Support @NotNull Condition isDistinctFrom(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)
 
 Compare this row value expression with another row value expression for distinctness.
- isDistinctFrom
 
 @NotNull @Support @NotNull Condition isDistinctFrom(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10)
 
 Compare this row value expression with another row value expression for distinctness.
- isDistinctFrom
 
 @NotNull @Support @NotNull Condition isDistinctFrom(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
 
 Compare this row value expression with another row value expression for distinctness.
- isNotDistinctFrom
 
 @NotNull @Support @NotNull Condition isNotDistinctFrom(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
 
 Compare this row value expression with another row value expression for distinctness.
- isNotDistinctFrom
 
 @NotNull @Support @NotNull Condition isNotDistinctFrom(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
 
 Compare this row value expression with another row value expression for distinctness.
- isNotDistinctFrom
 
 @NotNull @Support @NotNull Condition isNotDistinctFrom(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)
 
 Compare this row value expression with another row value expression for distinctness.
- isNotDistinctFrom
 
 @NotNull @Support @NotNull Condition isNotDistinctFrom(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10)
 
 Compare this row value expression with another row value expression for distinctness.
- isNotDistinctFrom
 
 @NotNull @Support @NotNull Condition isNotDistinctFrom(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
 
 Compare this row value expression with another row value expression for distinctness.
- lessThan
 
 @NotNull @Support @NotNull Condition lessThan(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
 
 Compare this row value expression with another row value expression for order.
 Row order comparison predicates can be emulated in those databases that do not support such predicates natively: (A, B, C) < (1, 2, 3) is equivalent to A < 1 OR (A = 1 AND B < 2) OR (A = 1 AND B = 2 AND C < 3)
- lessThan
 
 @NotNull @Support @NotNull Condition lessThan(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
 
 Compare this row value expression with a record for order.
 
 See Also:
 
 lessThan(Row10)
- lessThan
 
 @NotNull @Support @NotNull Condition lessThan(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)
 
 Compare this row value expression with another row value expression for order.
 
 See Also:
 
 lessThan(Row10)
- lessThan
 
 @NotNull @Support @NotNull Condition lessThan(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10)
 
 Compare this row value expression with another row value expression for order.
 
 See Also:
 
 lessThan(Row10)
- lessThan
 
 @NotNull @Support @NotNull Condition lessThan(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
 
 Compare this row value expression with a subselect for order.
 
 See Also:
 
 lessThan(Row10)
- lessThan
 
 @NotNull @Support @NotNull Condition lessThan(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
 
 Compare this row value expression with a subselect for order.
 
 See Also:
 
 DSL.all(Field), DSL.all(Select), DSL.all(Object...), DSL.any(Field), DSL.any(Select), DSL.any(Object...)
- lt
 
 @NotNull @Support @NotNull Condition lt(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
 
 Compare this row value expression with another row value expression for order.
 
 See Also:
 
 lessThan(Row10)
- lt
 
 @NotNull @Support @NotNull Condition lt(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
 
 Compare this row value expression with a record for order.
 
 See Also:
 
 lessThan(Row10)
- lt
 
 @NotNull @Support @NotNull Condition lt(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)
 
 Compare this row value expression with another row value expression for order.
 
 See Also:
 
 lessThan(Row10)
- lt
 
 @NotNull @Support @NotNull Condition lt(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10)
 
 Compare this row value expression with another row value expression for order.
 
 See Also:
 
 lessThan(Row10)
- lt
 
 @NotNull @Support @NotNull Condition lt(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
 
 Compare this row value expression with a subselect for order.
 
 See Also:
 
 lessThan(Row10)
- lt
 
 @NotNull @Support @NotNull Condition lt(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
 
 Compare this row value expression with a subselect for order.
 
 See Also:
 
 DSL.all(Field), DSL.all(Select), DSL.all(Object...), DSL.any(Field), DSL.any(Select), DSL.any(Object...)
- lessOrEqual
 
 @NotNull @Support @NotNull Condition lessOrEqual(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
 
 Compare this row value expression with another row value expression for order.
 Row order comparison predicates can be emulated in those databases that do not support such predicates natively: (A, B) <= (1, 2) is equivalent to A < 1 OR (A = 1 AND B < 2) OR (A = 1 AND B = 2)
- lessOrEqual
 
 @NotNull @Support @NotNull Condition lessOrEqual(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
 
 Compare this row value expression with a record for order.
 
 See Also:
 
 lessOrEqual(Row10)
- lessOrEqual
 
 @NotNull @Support @NotNull Condition lessOrEqual(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)
 
 Compare this row value expression with another row value expression for order.
 
 See Also:
 
 lessOrEqual(Row10)
- lessOrEqual
 
 @NotNull @Support @NotNull Condition lessOrEqual(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10)
 
 Compare this row value expression with another row value expression for order.
 
 See Also:
 
 lessOrEqual(Row10)
- lessOrEqual
 
 @NotNull @Support @NotNull Condition lessOrEqual(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
 
 Compare this row value expression with a subselect for order.
 
 See Also:
 
 lessOrEqual(Row10)
- lessOrEqual
 
 @NotNull @Support @NotNull Condition lessOrEqual(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
 
 Compare this row value expression with a subselect for order.
 
 See Also:
 
 DSL.all(Field), DSL.all(Select), DSL.all(Object...), DSL.any(Field), DSL.any(Select), DSL.any(Object...)
- le
 
 @NotNull @Support @NotNull Condition le(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
 
 Compare this row value expression with another row value expression for order.
 
 See Also:
 
 lessOrEqual(Row10)
- le
 
 @NotNull @Support @NotNull Condition le(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
 
 Compare this row value expression with a record for order.
 
 See Also:
 
 lessOrEqual(Row10)
- le
 
 @NotNull @Support @NotNull Condition le(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)
 
 Compare this row value expression with another row value expression for order.
 
 See Also:
 
 lessOrEqual(Row10)
- le
 
 @NotNull @Support @NotNull Condition le(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10)
 
 Compare this row value expression with another row value expression for order.
 
 See Also:
 
 lessOrEqual(Row10)
- le
 
 @NotNull @Support @NotNull Condition le(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
 
 Compare this row value expression with a subselect for order.
 
 See Also:
 
 lessOrEqual(Row10)
- le
 
 @NotNull @Support @NotNull Condition le(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
 
 Compare this row value expression with a subselect for order.
 
 See Also:
 
 DSL.all(Field), DSL.all(Select), DSL.all(Object...), DSL.any(Field), DSL.any(Select), DSL.any(Object...)
- greaterThan
 
 @NotNull @Support @NotNull Condition greaterThan(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
 
 Compare this row value expression with another row value expression for order.
 Row order comparison predicates can be emulated in those databases that do not support such predicates natively: (A, B, C) > (1, 2, 3) is equivalent to A > 1 OR (A = 1 AND B > 2) OR (A = 1 AND B = 2 AND C > 3)
- greaterThan
 
 @NotNull @Support @NotNull Condition greaterThan(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
 
 Compare this row value expression with a record for order.
 
 See Also:
 
 greaterThan(Row10)
- greaterThan
 
 @NotNull @Support @NotNull Condition greaterThan(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)
 
 Compare this row value expression with another row value expression for order.
 
 See Also:
 
 greaterThan(Row10)
- greaterThan
 
 @NotNull @Support @NotNull Condition greaterThan(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10)
 
 Compare this row value expression with another row value expression for order.
 
 See Also:
 
 greaterThan(Row10)
- greaterThan
 
 @NotNull @Support @NotNull Condition greaterThan(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
 
 Compare this row value expression with a subselect for order.
 
 See Also:
 
 greaterThan(Row10)
- greaterThan
 
 @NotNull @Support @NotNull Condition greaterThan(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
 
 Compare this row value expression with a subselect for order.
 
 See Also:
 
 DSL.all(Field), DSL.all(Select), DSL.all(Object...), DSL.any(Field), DSL.any(Select), DSL.any(Object...)
- gt
 
 @NotNull @Support @NotNull Condition gt(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
 
 Compare this row value expression with another row value expression for order.
 
 See Also:
 
 greaterThan(Row10)
- gt
 
 @NotNull @Support @NotNull Condition gt(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
 
 Compare this row value expression with a record for order.
 
 See Also:
 
 greaterThan(Row10)
- gt
 
 @NotNull @Support @NotNull Condition gt(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)
 
 Compare this row value expression with another row value expression for order.
 
 See Also:
 
 greaterThan(Row10)
- gt
 
 @NotNull @Support @NotNull Condition gt(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10)
 
 Compare this row value expression with another row value expression for order.
 
 See Also:
 
 greaterThan(Row10)
- gt
 
 @NotNull @Support @NotNull Condition gt(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
 
 Compare this row value expression with a subselect for order.
 
 See Also:
 
 greaterThan(Row10)
- gt
 
 @NotNull @Support @NotNull Condition gt(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
 
 Compare this row value expression with a subselect for order.
 
 See Also:
 
 DSL.all(Field), DSL.all(Select), DSL.all(Object...), DSL.any(Field), DSL.any(Select), DSL.any(Object...)
- greaterOrEqual
 
 @NotNull @Support @NotNull Condition greaterOrEqual(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
 
 Compare this row value expression with another row value expression for order.
 Row order comparison predicates can be emulated in those databases that do not support such predicates natively: (A, B) >= (1, 2) is equivalent to A > 1 OR (A = 1 AND B > 2) OR (A = 1 AND B = 2)
- greaterOrEqual
 
 @NotNull @Support @NotNull Condition greaterOrEqual(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
 
 Compare this row value expression with a record for order.
 
 See Also:
 
 greaterOrEqual(Row10)
- greaterOrEqual
 
 @NotNull @Support @NotNull Condition greaterOrEqual(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)
 
 Compare this row value expression with another row value expression for order.
 
 See Also:
 
 greaterOrEqual(Row10)
- greaterOrEqual
 
 @NotNull @Support @NotNull Condition greaterOrEqual(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10)
 
 Compare this row value expression with another row value expression for order.
 
 See Also:
 
 greaterOrEqual(Row10)
- greaterOrEqual
 
 @NotNull @Support @NotNull Condition greaterOrEqual(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
 
 Compare this row value expression with a subselect for order.
 
 See Also:
 
 greaterOrEqual(Row10)
- greaterOrEqual
 
 @NotNull @Support @NotNull Condition greaterOrEqual(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
 
 Compare this row value expression with a subselect for order.
 
 See Also:
 
 DSL.all(Field), DSL.all(Select), DSL.all(Object...), DSL.any(Field), DSL.any(Select), DSL.any(Object...)
- ge
 
 @NotNull @Support @NotNull Condition ge(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
 
 Compare this row value expression with another row value expression for order.
 
 See Also:
 
 greaterOrEqual(Row10)
- ge
 
 @NotNull @Support @NotNull Condition ge(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
 
 Compare this row value expression with a record for order.
 
 See Also:
 
 greaterOrEqual(Row10)
- ge
 
 @NotNull @Support @NotNull Condition ge(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)
 
 Compare this row value expression with another row value expression for order.
 
 See Also:
 
 greaterOrEqual(Row10)
- ge
 
 @NotNull @Support @NotNull Condition ge(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10)
 
 Compare this row value expression with another row value expression for order.
 
 See Also:
 
 greaterOrEqual(Row10)
- ge
 
 @NotNull @Support @NotNull Condition ge(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
 
 Compare this row value expression with a subselect for order.
 
 See Also:
 
 greaterOrEqual(Row10)
- ge
 
 @NotNull @Support @NotNull Condition ge(QuantifiedSelect<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
 
 Compare this row value expression with a subselect for order.
 
 See Also:
 
 DSL.all(Field), DSL.all(Select), DSL.all(Object...), DSL.any(Field), DSL.any(Select), DSL.any(Object...)
- between
 
 @NotNull @Support @NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> between(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10)
 
 Check if this row value expression is within a range of two other row value expressions.
 
 See Also:
 
 between(Row10, Row10)
- between
 
 @NotNull @Support @NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> between(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7, Field<T8> minValue8, Field<T9> minValue9, Field<T10> minValue10)
 
 Check if this row value expression is within a range of two other row value expressions.
 
 See Also:
 
 between(Row10, Row10)
- between
 
 @NotNull @Support @NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> between(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue)
 
 Check if this row value expression is within a range of two other row value expressions.
 
 See Also:
 
 between(Row10, Row10)
- between
 
 @NotNull @Support @NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> between(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue)
 
 Check if this row value expression is within a range of two records.
 
 See Also:
 
 between(Row10, Row10)
- between
 
 @NotNull @Support @NotNull Condition between(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue, Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> maxValue)
 
 Check if this row value expression is within a range of two other row value expressions.
 This is the same as calling between(minValue).and(maxValue)
 The expression A BETWEEN B AND C is equivalent to the expression A >= B AND A <= C for those SQL dialects that do not properly support the BETWEEN predicate for row value expressions
- between
 
 @NotNull @Support @NotNull Condition between(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue, Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> maxValue)
 
 Check if this row value expression is within a range of two records.
 This is the same as calling between(minValue).and(maxValue)
 
 See Also:
 
 between(Row10, Row10)
- betweenSymmetric
 
 @NotNull @Support @NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> betweenSymmetric(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10)
 
 Check if this row value expression is within a symmetric range of two other row value expressions.
 
 See Also:
 
 betweenSymmetric(Row10, Row10)
- betweenSymmetric
 
 @NotNull @Support @NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> betweenSymmetric(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7, Field<T8> minValue8, Field<T9> minValue9, Field<T10> minValue10)
 
 Check if this row value expression is within a symmetric range of two other row value expressions.
 
 See Also:
 
 betweenSymmetric(Row10, Row10)
- betweenSymmetric
 
 @NotNull @Support @NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> betweenSymmetric(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue)
 
 Check if this row value expression is within a symmetric range of two other row value expressions.
 
 See Also:
 
 betweenSymmetric(Row10, Row10)
- betweenSymmetric
 
 @NotNull @Support @NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> betweenSymmetric(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue)
 
 Check if this row value expression is within a symmetric range of two records.
 
 See Also:
 
 betweenSymmetric(Row10, Row10)
- betweenSymmetric
 
 @NotNull @Support @NotNull Condition betweenSymmetric(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue, Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> maxValue)
 
 Check if this row value expression is within a symmetric range of two other row value expressions.
 This is the same as calling betweenSymmetric(minValue).and(maxValue)
 The expression A BETWEEN SYMMETRIC B AND C is equivalent to the expression (A >= B AND A <= C) OR (A >= C AND A <= B) for those SQL dialects that do not properly support the BETWEEN predicate for row value expressions
- betweenSymmetric
 
 @NotNull @Support @NotNull Condition betweenSymmetric(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue, Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> maxValue)
 
 Check if this row value expression is within a symmetric range of two records.
 This is the same as calling betweenSymmetric(minValue).and(maxValue)
 
 See Also:
 
 betweenSymmetric(Row10, Row10)
- notBetween
 
 @NotNull @Support @NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> notBetween(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10)
 
 Check if this row value expression is not within a range of two other row value expressions.
 
 See Also:
 
 between(Row10, Row10)
- notBetween
 
 @NotNull @Support @NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> notBetween(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7, Field<T8> minValue8, Field<T9> minValue9, Field<T10> minValue10)
 
 Check if this row value expression is not within a range of two other row value expressions.
 
 See Also:
 
 notBetween(Row10, Row10)
- notBetween
 
 @NotNull @Support @NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> notBetween(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue)
 
 Check if this row value expression is not within a range of two other row value expressions.
 
 See Also:
 
 notBetween(Row10, Row10)
- notBetween
 
 @NotNull @Support @NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> notBetween(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue)
 
 Check if this row value expression is within a range of two records.
 
 See Also:
 
 notBetween(Row10, Row10)
- notBetween
 
 @NotNull @Support @NotNull Condition notBetween(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue, Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> maxValue)
 
 Check if this row value expression is not within a range of two other row value expressions.
 This is the same as calling notBetween(minValue).and(maxValue)
 The expression A NOT BETWEEN B AND C is equivalent to the expression A C for those SQL dialects that do not properly support the BETWEEN predicate for row value expressions
- notBetween
 
 @NotNull @Support @NotNull Condition notBetween(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue, Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> maxValue)
 
 Check if this row value expression is within a range of two records.
 This is the same as calling notBetween(minValue).and(maxValue)
 
 See Also:
 
 notBetween(Row10, Row10)
- notBetweenSymmetric
 
 @NotNull @Support @NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> notBetweenSymmetric(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10)
 
 Check if this row value expression is not within a symmetric range of two other row value expressions.
 
 See Also:
 
 notBetweenSymmetric(Row10, Row10)
- notBetweenSymmetric
 
 @NotNull @Support @NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> notBetweenSymmetric(Field<T1> minValue1, Field<T2> minValue2, Field<T3> minValue3, Field<T4> minValue4, Field<T5> minValue5, Field<T6> minValue6, Field<T7> minValue7, Field<T8> minValue8, Field<T9> minValue9, Field<T10> minValue10)
 
 Check if this row value expression is not within a symmetric range of two other row value expressions.
 
 See Also:
 
 notBetweenSymmetric(Row10, Row10)
- notBetweenSymmetric
 
 @NotNull @Support @NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> notBetweenSymmetric(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue)
 
 Check if this row value expression is not within a symmetric range of two other row value expressions.
 
 See Also:
 
 notBetweenSymmetric(Row10, Row10)
- notBetweenSymmetric
 
 @NotNull @Support @NotNull BetweenAndStep10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> notBetweenSymmetric(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue)
 
 Check if this row value expression is not within a symmetric range of two records.
 
 See Also:
 
 notBetweenSymmetric(Row10, Row10)
- notBetweenSymmetric
 
 @NotNull @Support @NotNull Condition notBetweenSymmetric(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue, Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> maxValue)
 
 Check if this row value expression is not within a symmetric range of two other row value expressions.
 This is the same as calling notBetweenSymmetric(minValue).and(maxValue)
 The expression A NOT BETWEEN SYMMETRIC B AND C is equivalent to the expression (A C) AND (A < C OR A > B) for those SQL dialects that do not properly support the BETWEEN predicate for row value expressions
- notBetweenSymmetric
 
 @NotNull @Support @NotNull Condition notBetweenSymmetric(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> minValue, Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> maxValue)
 
 Check if this row value expression is not within a symmetric range of two records.
 This is the same as calling notBetweenSymmetric(minValue).and(maxValue)
 
 See Also:
 
 notBetweenSymmetric(Row10, Row10)
- in
 
 @NotNull @Support @NotNull Condition in(Collection<? extends Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> rows)
 Compare this row value expression with a set of row value expressions for equality.
 Row IN predicates can be emulated in those databases that do not support such predicates natively: (A, B) IN ((1, 2), (3, 4)) is equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4)), which is equivalent to (A = 1 AND B = 2) OR (A = 3 AND B = 4)
 Note that generating dynamic SQL with arbitrary-length IN predicates can cause cursor cache contention in some databases that use unique SQL strings as a statement identifier (e.g. SQLDialect.ORACLE). In order to prevent such problems, you could use Settings.isInListPadding() to produce less distinct SQL strings (see also [#5600]), or you could avoid IN lists, and replace them with:
 
 IN predicates on temporary tables
 
 IN predicates on unnested array bind variables
 See Also:
 
 Rows.toRowList(Function, Function, Function, Function, Function, Function, Function, Function, Function, Function)
- in
 
 @NotNull @Support @NotNull Condition in(Result<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> result)
 Compare this row value expression with a set of records for equality.
 Row IN predicates can be emulated in those databases that do not support such predicates natively: (A, B) IN ((1, 2), (3, 4)) is equivalent to ((A, B) = (1, 2)) OR ((A, B) = (3, 4)), which is equivalent to (A = 1 AND B = 2) OR (A = 3 AND B = 4)
 Note that generating dynamic SQL with arbitrary-length IN predicates can cause cursor cache contention in some databases that use unique SQL strings as a statement identifier (e.g. SQLDialect.ORACLE). In order to prevent such problems, you could use Settings.isInListPadding() to produce less distinct SQL strings (see also [#5600]), or you could avoid IN lists, and replace them with:
 
 IN predicates on temporary tables
 
 IN predicates on unnested array bind variables
- in
 
 @NotNull @Support @NotNull Condition in(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>... rows)
 Compare this row value expression with a set of row value expressions for equality.
 Note that generating dynamic SQL with arbitrary-length IN predicates can cause cursor cache contention in some databases that use unique SQL strings as a statement identifier (e.g. SQLDialect.ORACLE). In order to prevent such problems, you could use Settings.isInListPadding() to produce less distinct SQL strings (see also [#5600]), or you could avoid IN lists, and replace them with:
 
 IN predicates on temporary tables
 
 IN predicates on unnested array bind variables
 See Also:
 
 in(Collection), Rows.toRowArray(Function, Function, Function, Function, Function, Function, Function, Function, Function, Function)
- in
 
 @NotNull @Support @NotNull Condition in(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>... record)
 Compare this row value expression with a set of records for equality.
 Note that generating dynamic SQL with arbitrary-length IN predicates can cause cursor cache contention in some databases that use unique SQL strings as a statement identifier (e.g. SQLDialect.ORACLE). In order to prevent such problems, you could use Settings.isInListPadding() to produce less distinct SQL strings (see also [#5600]), or you could avoid IN lists, and replace them with:
 
 IN predicates on temporary tables
 
 IN predicates on unnested array bind variables
 See Also:
 
 in(Collection)
- in
 
 @NotNull @Support @NotNull Condition in(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
 
 Compare this row value expression with a subselect for equality.
 
 See Also:
 
 in(Collection)
- notIn
 
 @NotNull @Support @NotNull Condition notIn(Collection<? extends Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> rows)
 Compare this row value expression with a set of row value expressions for equality.
 Row NOT IN predicates can be emulated in those databases that do not support such predicates natively: (A, B) NOT IN ((1, 2), (3, 4)) is equivalent to NOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4))), which is equivalent to NOT((A = 1 AND B = 2) OR (A = 3 AND B = 4))
 Note that generating dynamic SQL with arbitrary-length NOT IN predicates can cause cursor cache contention in some databases that use unique SQL strings as a statement identifier (e.g. SQLDialect.ORACLE). In order to prevent such problems, you could use Settings.isInListPadding() to produce less distinct SQL strings (see also [#5600]), or you could avoid IN lists, and replace them with:
 
 NOT IN predicates on temporary tables
 
 NOT IN predicates on unnested array bind variables
 See Also:
 
 Rows.toRowList(Function, Function, Function, Function, Function, Function, Function, Function, Function, Function)
- notIn
 
 @NotNull @Support @NotNull Condition notIn(Result<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> result)
 Compare this row value expression with a set of records for equality.
 Row NOT IN predicates can be emulated in those databases that do not support such predicates natively: (A, B) NOT IN ((1, 2), (3, 4)) is equivalent to NOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4))), which is equivalent to NOT((A = 1 AND B = 2) OR (A = 3 AND B = 4))
 Note that generating dynamic SQL with arbitrary-length NOT IN predicates can cause cursor cache contention in some databases that use unique SQL strings as a statement identifier (e.g. SQLDialect.ORACLE). In order to prevent such problems, you could use Settings.isInListPadding() to produce less distinct SQL strings (see also [#5600]), or you could avoid IN lists, and replace them with:
 
 NOT IN predicates on temporary tables
 
 NOT IN predicates on unnested array bind variables
- notIn
 
 @NotNull @Support @NotNull Condition notIn(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>... rows)
 Compare this row value expression with a set of row value expressions for equality.
 Note that generating dynamic SQL with arbitrary-length NOT IN predicates can cause cursor cache contention in some databases that use unique SQL strings as a statement identifier (e.g. SQLDialect.ORACLE). In order to prevent such problems, you could use Settings.isInListPadding() to produce less distinct SQL strings (see also [#5600]), or you could avoid IN lists, and replace them with:
 
 NOT IN predicates on temporary tables
 
 NOT IN predicates on unnested array bind variables
 See Also:
 
 notIn(Collection), Rows.toRowArray(Function, Function, Function, Function, Function, Function, Function, Function, Function, Function)
- notIn
 
 @NotNull @Support @NotNull Condition notIn(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>... record)
 Compare this row value expression with a set of records for non-equality.
 Note that generating dynamic SQL with arbitrary-length NOT IN predicates can cause cursor cache contention in some databases that use unique SQL strings as a statement identifier (e.g. SQLDialect.ORACLE). In order to prevent such problems, you could use Settings.isInListPadding() to produce less distinct SQL strings (see also [#5600]), or you could avoid IN lists, and replace them with:
 
 NOT IN predicates on temporary tables
 
 NOT IN predicates on unnested array bind variables
 See Also:
 
 notIn(Collection)
- notIn
 
 @NotNull @Support @NotNull Condition notIn(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> select)
 
 Compare this row value expression with a subselect for non-equality.
 
 See Also:
 
 notIn(Collection)
- set
 
 @NotNull @Support({AURORA_POSTGRES,DB2,EXASOL,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER}) @NotNull Statement set(Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> row)
 
 Assign a value to this set of variables.
- set
 
 @NotNull @Support({AURORA_POSTGRES,DB2,EXASOL,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER}) @NotNull Statement set(Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10> record)
 
 Assign a value to this set of variables.
- set
 
 @NotNull @Support({AURORA_POSTGRES,DB2,EXASOL,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER}) @NotNull Statement set(T1 t1, T2 t2, T3 t3, T4 t4, T5 t5, T6 t6, T7 t7, T8 t8, T9 t9, T10 t10)
 
 Assign a value to this set of variables.
- set
 
 @NotNull @Support({AURORA_POSTGRES,DB2,EXASOL,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER}) @NotNull Statement set(Field<T1> t1, Field<T2> t2, Field<T3> t3, Field<T4> t4, Field<T5> t5, Field<T6> t6, Field<T7> t7, Field<T8> t8, Field<T9> t9, Field<T10> t10)
 
 Assign a value to this set of variables.
- set
 
 @NotNull @Support({AURORA_POSTGRES,DB2,HANA,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER}) @NotNull Statement set(Select<? extends Record10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>> value)
 
 Assign a value to this set of variables.

Interface Row10<T1,​T2,​T3,​T4,​T5,​T6,​T7,​T8,​T9,​T10>

Method Summary

Methods inherited from interface org.jooq.Fields

Methods inherited from interface org.jooq.Named

Methods inherited from interface org.jooq.QueryPart

Methods inherited from interface org.jooq.Row

Methods inherited from interface org.jooq.SelectField

Methods inherited from interface org.jooq.Typed

Method Details

mapping

mapping

field1

field2

field3

field4

field5

field6

field7

field8

field9

field10

compare

compare

compare

compare

compare

compare

equal

equal

equal

equal

equal

equal

eq

eq

eq

eq

eq

eq

notEqual

notEqual

notEqual

notEqual

notEqual

notEqual

ne

ne

ne

ne

ne

ne

isDistinctFrom

isDistinctFrom

isDistinctFrom

isDistinctFrom

isDistinctFrom

isNotDistinctFrom

isNotDistinctFrom

isNotDistinctFrom

isNotDistinctFrom

isNotDistinctFrom

lessThan

lessThan

lessThan

lessThan

lessThan

lessThan

lt

lt

lt

lt

lt

lt

lessOrEqual

lessOrEqual

lessOrEqual

lessOrEqual

lessOrEqual

lessOrEqual

le

Interface Row10<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10>