Module org.jooq

Package org.jooq

Interface Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>

All Superinterfaces:

FieldOrRow, QueryPart, Row, Serializable

public interface Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>
extends Row

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 BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>	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, Field<T11> minValue11, Field<T12> minValue12, Field<T13> minValue13, Field<T14> minValue14, Field<T15> minValue15, Field<T16> minValue16)	Check if this row value expression is within a range of two other row value expressions.
@NotNull BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>	between(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> minValue)	Check if this row value expression is within a range of two records.
@NotNull Condition	between(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> minValue, Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> maxValue)	Check if this row value expression is within a range of two records.
@NotNull BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>	between(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> minValue)	Check if this row value expression is within a range of two other row value expressions.
@NotNull Condition	between(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> minValue, Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> maxValue)	Check if this row value expression is within a range of two other row value expressions.
@NotNull BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>	between(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11, T12 minValue12, T13 minValue13, T14 minValue14, T15 minValue15, T16 minValue16)	Check if this row value expression is within a range of two other row value expressions.
@NotNull BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>	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, Field<T11> minValue11, Field<T12> minValue12, Field<T13> minValue13, Field<T14> minValue14, Field<T15> minValue15, Field<T16> minValue16)	Check if this row value expression is within a symmetric range of two other row value expressions.
@NotNull BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>	betweenSymmetric(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> minValue)	Check if this row value expression is within a symmetric range of two records.
@NotNull Condition	betweenSymmetric(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> minValue, Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> maxValue)	Check if this row value expression is within a symmetric range of two records.
@NotNull BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>	betweenSymmetric(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> minValue)	Check if this row value expression is within a symmetric range of two other row value expressions.
@NotNull Condition	betweenSymmetric(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> minValue, Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> maxValue)	Check if this row value expression is within a symmetric range of two other row value expressions.
@NotNull BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>	betweenSymmetric(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11, T12 minValue12, T13 minValue13, T14 minValue14, T15 minValue15, T16 minValue16)	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, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16)	Compare this row value expression with another row value expression using a dynamic comparator.
@NotNull Condition	compare(Comparator comparator, QuantifiedSelect<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)	Compare this row value expression with a subselect using a dynamic comparator.
@NotNull Condition	compare(Comparator comparator, Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> record)	Compare this row value expression with a record using a dynamic comparator.
@NotNull Condition	compare(Comparator comparator, Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> row)	Compare this row value expression with another row value expression using a dynamic comparator.
@NotNull Condition	compare(Comparator comparator, Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> 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, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16)	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, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16)	Compare this row value expression with another row value expression for equality.
@NotNull Condition	eq(QuantifiedSelect<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	eq(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> record)	Compare this row value expression with a record for equality.
@NotNull Condition	eq(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> row)	Compare this row value expression with another row value expression for equality.
@NotNull Condition	eq(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> 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, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16)	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, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16)	Compare this row value expression with another row value expression for equality.
@NotNull Condition	equal(QuantifiedSelect<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)	Compare this row value expression with a subselect for equality.
@NotNull Condition	equal(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> record)	Compare this row value expression with a record for equality.
@NotNull Condition	equal(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> row)	Compare this row value expression with another row value expression for equality.
@NotNull Condition	equal(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> 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, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16)	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<T11>	field11()	Get the eleventh field.
@NotNull Field<T12>	field12()	Get the twelfth field.
@NotNull Field<T13>	field13()	Get the thirteenth field.
@NotNull Field<T14>	field14()	Get the fourteenth field.
@NotNull Field<T15>	field15()	Get the fifteenth field.
@NotNull Field<T16>	field16()	Get the sixteenth 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, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16)	Compare this row value expression with another row value expression for order.
@NotNull Condition	ge(QuantifiedSelect<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	ge(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> record)	Compare this row value expression with a record for order.
@NotNull Condition	ge(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> row)	Compare this row value expression with another row value expression for order.
@NotNull Condition	ge(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> 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, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16)	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, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16)	Compare this row value expression with another row value expression for order.
@NotNull Condition	greaterOrEqual(QuantifiedSelect<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	greaterOrEqual(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> record)	Compare this row value expression with a record for order.
@NotNull Condition	greaterOrEqual(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> row)	Compare this row value expression with another row value expression for order.
@NotNull Condition	greaterOrEqual(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> 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, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16)	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, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16)	Compare this row value expression with another row value expression for order.
@NotNull Condition	greaterThan(QuantifiedSelect<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	greaterThan(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> record)	Compare this row value expression with a record for order.
@NotNull Condition	greaterThan(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> row)	Compare this row value expression with another row value expression for order.
@NotNull Condition	greaterThan(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> 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, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16)	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, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16)	Compare this row value expression with another row value expression for order.
@NotNull Condition	gt(QuantifiedSelect<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	gt(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> record)	Compare this row value expression with a record for order.
@NotNull Condition	gt(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> row)	Compare this row value expression with another row value expression for order.
@NotNull Condition	gt(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> 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, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16)	Compare this row value expression with another row value expression for order.
@NotNull Condition	in(Collection<? extends Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> rows)	Compare this row value expression with a set of row value expressions for equality.
@NotNull Condition	in(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>... record)	Compare this row value expression with a set of records for equality.
@NotNull Condition	in(Result<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> result)	Compare this row value expression with a set of records for equality.
@NotNull Condition	in(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>... rows)	Compare this row value expression with a set of row value expressions for equality.
@NotNull Condition	in(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> 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, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	isDistinctFrom(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> record)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	isDistinctFrom(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> row)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	isDistinctFrom(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> 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, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16)	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, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	isNotDistinctFrom(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> record)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	isNotDistinctFrom(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> row)	Compare this row value expression with another row value expression for distinctness.
@NotNull Condition	isNotDistinctFrom(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> 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, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16)	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, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16)	Compare this row value expression with another row value expression for order.
@NotNull Condition	le(QuantifiedSelect<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	le(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> record)	Compare this row value expression with a record for order.
@NotNull Condition	le(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> row)	Compare this row value expression with another row value expression for order.
@NotNull Condition	le(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> 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, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16)	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, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16)	Compare this row value expression with another row value expression for order.
@NotNull Condition	lessOrEqual(QuantifiedSelect<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	lessOrEqual(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> record)	Compare this row value expression with a record for order.
@NotNull Condition	lessOrEqual(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> row)	Compare this row value expression with another row value expression for order.
@NotNull Condition	lessOrEqual(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> 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, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16)	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, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16)	Compare this row value expression with another row value expression for order.
@NotNull Condition	lessThan(QuantifiedSelect<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	lessThan(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> record)	Compare this row value expression with a record for order.
@NotNull Condition	lessThan(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> row)	Compare this row value expression with another row value expression for order.
@NotNull Condition	lessThan(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> 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, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16)	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, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16)	Compare this row value expression with another row value expression for order.
@NotNull Condition	lt(QuantifiedSelect<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)	Compare this row value expression with a subselect for order.
@NotNull Condition	lt(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> record)	Compare this row value expression with a record for order.
@NotNull Condition	lt(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> row)	Compare this row value expression with another row value expression for order.
@NotNull Condition	lt(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> 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, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16)	Compare this row value expression with another row value expression for order.
@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, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16)	Compare this row value expression with another row value expression for non-equality.
@NotNull Condition	ne(QuantifiedSelect<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	ne(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> record)	Compare this row value expression with a record for non-equality.
@NotNull Condition	ne(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> row)	Compare this row value expression with another row value expression for non-equality.
@NotNull Condition	ne(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> 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, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16)	Compare this row value expression with another row value expression for non-equality.
@NotNull BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>	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, Field<T11> minValue11, Field<T12> minValue12, Field<T13> minValue13, Field<T14> minValue14, Field<T15> minValue15, Field<T16> minValue16)	Check if this row value expression is not within a range of two other row value expressions.
@NotNull BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>	notBetween(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> minValue)	Check if this row value expression is within a range of two records.
@NotNull Condition	notBetween(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> minValue, Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> maxValue)	Check if this row value expression is within a range of two records.
@NotNull BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>	notBetween(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> minValue)	Check if this row value expression is not within a range of two other row value expressions.
@NotNull Condition	notBetween(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> minValue, Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> maxValue)	Check if this row value expression is not within a range of two other row value expressions.
@NotNull BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>	notBetween(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11, T12 minValue12, T13 minValue13, T14 minValue14, T15 minValue15, T16 minValue16)	Check if this row value expression is not within a range of two other row value expressions.
@NotNull BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>	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, Field<T11> minValue11, Field<T12> minValue12, Field<T13> minValue13, Field<T14> minValue14, Field<T15> minValue15, Field<T16> minValue16)	Check if this row value expression is not within a symmetric range of two other row value expressions.
@NotNull BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>	notBetweenSymmetric(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> minValue)	Check if this row value expression is not within a symmetric range of two records.
@NotNull Condition	notBetweenSymmetric(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> minValue, Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> maxValue)	Check if this row value expression is not within a symmetric range of two records.
@NotNull BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>	notBetweenSymmetric(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> minValue)	Check if this row value expression is not within a symmetric range of two other row value expressions.
@NotNull Condition	notBetweenSymmetric(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> minValue, Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> maxValue)	Check if this row value expression is not within a symmetric range of two other row value expressions.
@NotNull BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>	notBetweenSymmetric(T1 minValue1, T2 minValue2, T3 minValue3, T4 minValue4, T5 minValue5, T6 minValue6, T7 minValue7, T8 minValue8, T9 minValue9, T10 minValue10, T11 minValue11, T12 minValue12, T13 minValue13, T14 minValue14, T15 minValue15, T16 minValue16)	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, Field<T11> t11, Field<T12> t12, Field<T13> t13, Field<T14> t14, Field<T15> t15, Field<T16> t16)	Compare this row value expression with another row value expression for non-equality.
@NotNull Condition	notEqual(QuantifiedSelect<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)	Compare this row value expression with a subselect for non-equality.
@NotNull Condition	notEqual(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> record)	Compare this row value expression with a record for non-equality
@NotNull Condition	notEqual(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> row)	Compare this row value expression with another row value expression for non-equality.
@NotNull Condition	notEqual(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> 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, T11 t11, T12 t12, T13 t13, T14 t14, T15 t15, T16 t16)	Compare this row value expression with another row value expression for.
@NotNull Condition	notIn(Collection<? extends Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> rows)	Compare this row value expression with a set of row value expressions for equality.
@NotNull Condition	notIn(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>... record)	Compare this row value expression with a set of records for non-equality.
@NotNull Condition	notIn(Result<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> result)	Compare this row value expression with a set of records for equality.
@NotNull Condition	notIn(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>... rows)	Compare this row value expression with a set of row value expressions for equality.
@NotNull Condition	notIn(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)	Compare this row value expression with a subselect for non-equality.

Methods inherited from interface org.jooq.QueryPart

equals, hashCode, toString

Methods inherited from interface org.jooq.Row

dataType, dataType, dataType, dataTypes, field, field, field, field, field, field, field, field, field, field, fields, fields, fields, fields, fields, fieldStream, indexOf, indexOf, indexOf, isNotNull, isNull, size, type, type, type, types

Method Detail

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.

field11

@NotNull
@NotNull Field<T11> field11()

Get the eleventh field.

field12

@NotNull
@NotNull Field<T12> field12()

Get the twelfth field.

field13

@NotNull
@NotNull Field<T13> field13()

Get the thirteenth field.

field14

@NotNull
@NotNull Field<T14> field14()

Get the fourteenth field.

field15

@NotNull
@NotNull Field<T15> field15()

Get the fifteenth field.

field16

@NotNull
@NotNull Field<T16> field16()

Get the sixteenth field.

compare

@NotNull
@Support
@NotNull Condition compare(Comparator comparator,
                           Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> 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(Row16), notEqual(Row16), lessThan(Row16), lessOrEqual(Row16), greaterThan(Row16), greaterOrEqual(Row16)

compare

@NotNull
@Support
@NotNull Condition compare(Comparator comparator,
                           Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> 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(Record16), notEqual(Record16), lessThan(Record16), lessOrEqual(Record16), greaterThan(Record16), greaterOrEqual(Record16)

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,
                           T11 t11,
                           T12 t12,
                           T13 t13,
                           T14 t14,
                           T15 t15,
                           T16 t16)

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(Row16), notEqual(Row16), lessThan(Row16), lessOrEqual(Row16), greaterThan(Row16), greaterOrEqual(Row16)

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,
                           Field<T11> t11,
                           Field<T12> t12,
                           Field<T13> t13,
                           Field<T14> t14,
                           Field<T15> t15,
                           Field<T16> t16)

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(Row16), notEqual(Row16), lessThan(Row16), lessOrEqual(Row16), greaterThan(Row16), greaterOrEqual(Row16)

compare

@NotNull
@Support
@NotNull Condition compare(Comparator comparator,
                           Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> 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 Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> 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(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> 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(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> record)

Compare this row value expression with a record for equality.

See Also:

equal(Row16)

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,
                         T11 t11,
                         T12 t12,
                         T13 t13,
                         T14 t14,
                         T15 t15,
                         T16 t16)

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

See Also:

equal(Row16)

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,
                         Field<T11> t11,
                         Field<T12> t12,
                         Field<T13> t13,
                         Field<T14> t14,
                         Field<T15> t15,
                         Field<T16> t16)

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

See Also:

equal(Row16)

equal

@NotNull
@Support
@NotNull Condition equal(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)

Compare this row value expression with a subselect for equality.

See Also:

equal(Row16)

equal

@NotNull
@Support
@NotNull Condition equal(QuantifiedSelect<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> 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(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> row)

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

See Also:

equal(Row16)

eq

@NotNull
@Support
@NotNull Condition eq(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> record)

Compare this row value expression with a record for equality.

See Also:

equal(Row16)

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,
                      T11 t11,
                      T12 t12,
                      T13 t13,
                      T14 t14,
                      T15 t15,
                      T16 t16)

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

See Also:

equal(Row16)

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,
                      Field<T11> t11,
                      Field<T12> t12,
                      Field<T13> t13,
                      Field<T14> t14,
                      Field<T15> t15,
                      Field<T16> t16)

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

See Also:

equal(Row16)

eq

@NotNull
@Support
@NotNull Condition eq(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)

Compare this row value expression with a subselect for equality.

See Also:

equal(Row16)

eq

@NotNull
@Support
@NotNull Condition eq(QuantifiedSelect<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> 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(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> 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(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> record)

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

See Also:

notEqual(Row16)

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,
                            T11 t11,
                            T12 t12,
                            T13 t13,
                            T14 t14,
                            T15 t15,
                            T16 t16)

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

See Also:

notEqual(Row16)

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,
                            Field<T11> t11,
                            Field<T12> t12,
                            Field<T13> t13,
                            Field<T14> t14,
                            Field<T15> t15,
                            Field<T16> t16)

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

See Also:

notEqual(Row16)

notEqual

@NotNull
@Support
@NotNull Condition notEqual(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)

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

See Also:

notEqual(Row16)

notEqual

@NotNull
@Support
@NotNull Condition notEqual(QuantifiedSelect<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> 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(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> row)

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

See Also:

notEqual(Row16)

ne

@NotNull
@Support
@NotNull Condition ne(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> record)

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

See Also:

notEqual(Row16)

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,
                      T11 t11,
                      T12 t12,
                      T13 t13,
                      T14 t14,
                      T15 t15,
                      T16 t16)

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

See Also:

notEqual(Row16)

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,
                      Field<T11> t11,
                      Field<T12> t12,
                      Field<T13> t13,
                      Field<T14> t14,
                      Field<T15> t15,
                      Field<T16> t16)

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

See Also:

notEqual(Row16)

ne

@NotNull
@Support
@NotNull Condition ne(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)

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

See Also:

notEqual(Row16)

ne

@NotNull
@Support
@NotNull Condition ne(QuantifiedSelect<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> 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(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> row)

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

isDistinctFrom

@NotNull
@Support
@NotNull Condition isDistinctFrom(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> 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,
                                  T11 t11,
                                  T12 t12,
                                  T13 t13,
                                  T14 t14,
                                  T15 t15,
                                  T16 t16)

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,
                                  Field<T11> t11,
                                  Field<T12> t12,
                                  Field<T13> t13,
                                  Field<T14> t14,
                                  Field<T15> t15,
                                  Field<T16> t16)

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

isDistinctFrom

@NotNull
@Support
@NotNull Condition isDistinctFrom(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)

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

isNotDistinctFrom

@NotNull
@Support
@NotNull Condition isNotDistinctFrom(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> row)

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

isNotDistinctFrom

@NotNull
@Support
@NotNull Condition isNotDistinctFrom(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> 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,
                                     T11 t11,
                                     T12 t12,
                                     T13 t13,
                                     T14 t14,
                                     T15 t15,
                                     T16 t16)

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,
                                     Field<T11> t11,
                                     Field<T12> t12,
                                     Field<T13> t13,
                                     Field<T14> t14,
                                     Field<T15> t15,
                                     Field<T16> t16)

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

isNotDistinctFrom

@NotNull
@Support
@NotNull Condition isNotDistinctFrom(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)

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

lessThan

@NotNull
@Support
@NotNull Condition lessThan(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> 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(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> record)

Compare this row value expression with a record for order.

See Also:

lessThan(Row16)

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,
                            T11 t11,
                            T12 t12,
                            T13 t13,
                            T14 t14,
                            T15 t15,
                            T16 t16)

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

See Also:

lessThan(Row16)

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,
                            Field<T11> t11,
                            Field<T12> t12,
                            Field<T13> t13,
                            Field<T14> t14,
                            Field<T15> t15,
                            Field<T16> t16)

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

See Also:

lessThan(Row16)

lessThan

@NotNull
@Support
@NotNull Condition lessThan(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)

Compare this row value expression with a subselect for order.

See Also:

lessThan(Row16)

lessThan

@NotNull
@Support
@NotNull Condition lessThan(QuantifiedSelect<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> 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(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> row)

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

See Also:

lessThan(Row16)

lt

@NotNull
@Support
@NotNull Condition lt(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> record)

Compare this row value expression with a record for order.

See Also:

lessThan(Row16)

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,
                      T11 t11,
                      T12 t12,
                      T13 t13,
                      T14 t14,
                      T15 t15,
                      T16 t16)

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

See Also:

lessThan(Row16)

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,
                      Field<T11> t11,
                      Field<T12> t12,
                      Field<T13> t13,
                      Field<T14> t14,
                      Field<T15> t15,
                      Field<T16> t16)

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

See Also:

lessThan(Row16)

lt

@NotNull
@Support
@NotNull Condition lt(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)

Compare this row value expression with a subselect for order.

See Also:

lessThan(Row16)

lt

@NotNull
@Support
@NotNull Condition lt(QuantifiedSelect<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> 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(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> 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(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> record)

Compare this row value expression with a record for order.

See Also:

lessOrEqual(Row16)

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,
                               T11 t11,
                               T12 t12,
                               T13 t13,
                               T14 t14,
                               T15 t15,
                               T16 t16)

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

See Also:

lessOrEqual(Row16)

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,
                               Field<T11> t11,
                               Field<T12> t12,
                               Field<T13> t13,
                               Field<T14> t14,
                               Field<T15> t15,
                               Field<T16> t16)

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

See Also:

lessOrEqual(Row16)

lessOrEqual

@NotNull
@Support
@NotNull Condition lessOrEqual(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)

Compare this row value expression with a subselect for order.

See Also:

lessOrEqual(Row16)

lessOrEqual

@NotNull
@Support
@NotNull Condition lessOrEqual(QuantifiedSelect<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> 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(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> row)

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

See Also:

lessOrEqual(Row16)

le

@NotNull
@Support
@NotNull Condition le(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> record)

Compare this row value expression with a record for order.

See Also:

lessOrEqual(Row16)

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,
                      T11 t11,
                      T12 t12,
                      T13 t13,
                      T14 t14,
                      T15 t15,
                      T16 t16)

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

See Also:

lessOrEqual(Row16)

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,
                      Field<T11> t11,
                      Field<T12> t12,
                      Field<T13> t13,
                      Field<T14> t14,
                      Field<T15> t15,
                      Field<T16> t16)

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

See Also:

lessOrEqual(Row16)

le

@NotNull
@Support
@NotNull Condition le(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)

Compare this row value expression with a subselect for order.

See Also:

lessOrEqual(Row16)

le

@NotNull
@Support
@NotNull Condition le(QuantifiedSelect<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> 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(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> 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(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> record)

Compare this row value expression with a record for order.

See Also:

greaterThan(Row16)

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,
                               T11 t11,
                               T12 t12,
                               T13 t13,
                               T14 t14,
                               T15 t15,
                               T16 t16)

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

See Also:

greaterThan(Row16)

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,
                               Field<T11> t11,
                               Field<T12> t12,
                               Field<T13> t13,
                               Field<T14> t14,
                               Field<T15> t15,
                               Field<T16> t16)

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

See Also:

greaterThan(Row16)

greaterThan

@NotNull
@Support
@NotNull Condition greaterThan(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)

Compare this row value expression with a subselect for order.

See Also:

greaterThan(Row16)

greaterThan

@NotNull
@Support
@NotNull Condition greaterThan(QuantifiedSelect<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> 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(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> row)

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

See Also:

greaterThan(Row16)

gt

@NotNull
@Support
@NotNull Condition gt(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> record)

Compare this row value expression with a record for order.

See Also:

greaterThan(Row16)

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,
                      T11 t11,
                      T12 t12,
                      T13 t13,
                      T14 t14,
                      T15 t15,
                      T16 t16)

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

See Also:

greaterThan(Row16)

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,
                      Field<T11> t11,
                      Field<T12> t12,
                      Field<T13> t13,
                      Field<T14> t14,
                      Field<T15> t15,
                      Field<T16> t16)

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

See Also:

greaterThan(Row16)

gt

@NotNull
@Support
@NotNull Condition gt(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)

Compare this row value expression with a subselect for order.

See Also:

greaterThan(Row16)

gt

@NotNull
@Support
@NotNull Condition gt(QuantifiedSelect<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> 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(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> 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(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> record)

Compare this row value expression with a record for order.

See Also:

greaterOrEqual(Row16)

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,
                                  T11 t11,
                                  T12 t12,
                                  T13 t13,
                                  T14 t14,
                                  T15 t15,
                                  T16 t16)

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

See Also:

greaterOrEqual(Row16)

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,
                                  Field<T11> t11,
                                  Field<T12> t12,
                                  Field<T13> t13,
                                  Field<T14> t14,
                                  Field<T15> t15,
                                  Field<T16> t16)

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

See Also:

greaterOrEqual(Row16)

greaterOrEqual

@NotNull
@Support
@NotNull Condition greaterOrEqual(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)

Compare this row value expression with a subselect for order.

See Also:

greaterOrEqual(Row16)

greaterOrEqual

@NotNull
@Support
@NotNull Condition greaterOrEqual(QuantifiedSelect<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> 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(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> row)

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

See Also:

greaterOrEqual(Row16)

ge

@NotNull
@Support
@NotNull Condition ge(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> record)

Compare this row value expression with a record for order.

See Also:

greaterOrEqual(Row16)

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,
                      T11 t11,
                      T12 t12,
                      T13 t13,
                      T14 t14,
                      T15 t15,
                      T16 t16)

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

See Also:

greaterOrEqual(Row16)

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,
                      Field<T11> t11,
                      Field<T12> t12,
                      Field<T13> t13,
                      Field<T14> t14,
                      Field<T15> t15,
                      Field<T16> t16)

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

See Also:

greaterOrEqual(Row16)

ge

@NotNull
@Support
@NotNull Condition ge(Select<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)

Compare this row value expression with a subselect for order.

See Also:

greaterOrEqual(Row16)

ge

@NotNull
@Support
@NotNull Condition ge(QuantifiedSelect<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> 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 BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> between(T1 minValue1,
                                                                                                                                                                                    T2 minValue2,
                                                                                                                                                                                    T3 minValue3,
                                                                                                                                                                                    T4 minValue4,
                                                                                                                                                                                    T5 minValue5,
                                                                                                                                                                                    T6 minValue6,
                                                                                                                                                                                    T7 minValue7,
                                                                                                                                                                                    T8 minValue8,
                                                                                                                                                                                    T9 minValue9,
                                                                                                                                                                                    T10 minValue10,
                                                                                                                                                                                    T11 minValue11,
                                                                                                                                                                                    T12 minValue12,
                                                                                                                                                                                    T13 minValue13,
                                                                                                                                                                                    T14 minValue14,
                                                                                                                                                                                    T15 minValue15,
                                                                                                                                                                                    T16 minValue16)

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

See Also:

between(Row16, Row16)

between

@NotNull
@Support
@NotNull BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> 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,
                                                                                                                                                                                    Field<T11> minValue11,
                                                                                                                                                                                    Field<T12> minValue12,
                                                                                                                                                                                    Field<T13> minValue13,
                                                                                                                                                                                    Field<T14> minValue14,
                                                                                                                                                                                    Field<T15> minValue15,
                                                                                                                                                                                    Field<T16> minValue16)

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

See Also:

between(Row16, Row16)

between

@NotNull
@Support
@NotNull BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> between(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> minValue)

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

See Also:

between(Row16, Row16)

between

@NotNull
@Support
@NotNull BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> between(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> minValue)

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

See Also:

between(Row16, Row16)

between

@NotNull
@Support
@NotNull Condition between(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> minValue,
                           Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> 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(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> minValue,
                           Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> 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(Row16, Row16)

betweenSymmetric

@NotNull
@Support
@NotNull BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> betweenSymmetric(T1 minValue1,
                                                                                                                                                                                             T2 minValue2,
                                                                                                                                                                                             T3 minValue3,
                                                                                                                                                                                             T4 minValue4,
                                                                                                                                                                                             T5 minValue5,
                                                                                                                                                                                             T6 minValue6,
                                                                                                                                                                                             T7 minValue7,
                                                                                                                                                                                             T8 minValue8,
                                                                                                                                                                                             T9 minValue9,
                                                                                                                                                                                             T10 minValue10,
                                                                                                                                                                                             T11 minValue11,
                                                                                                                                                                                             T12 minValue12,
                                                                                                                                                                                             T13 minValue13,
                                                                                                                                                                                             T14 minValue14,
                                                                                                                                                                                             T15 minValue15,
                                                                                                                                                                                             T16 minValue16)

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

See Also:

betweenSymmetric(Row16, Row16)

betweenSymmetric

@NotNull
@Support
@NotNull BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> 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,
                                                                                                                                                                                             Field<T11> minValue11,
                                                                                                                                                                                             Field<T12> minValue12,
                                                                                                                                                                                             Field<T13> minValue13,
                                                                                                                                                                                             Field<T14> minValue14,
                                                                                                                                                                                             Field<T15> minValue15,
                                                                                                                                                                                             Field<T16> minValue16)

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

See Also:

betweenSymmetric(Row16, Row16)

betweenSymmetric

@NotNull
@Support
@NotNull BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> betweenSymmetric(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> minValue)

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

See Also:

betweenSymmetric(Row16, Row16)

betweenSymmetric

@NotNull
@Support
@NotNull BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> betweenSymmetric(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> minValue)

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

See Also:

betweenSymmetric(Row16, Row16)

betweenSymmetric

@NotNull
@Support
@NotNull Condition betweenSymmetric(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> minValue,
                                    Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> 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(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> minValue,
                                    Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> 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(Row16, Row16)

notBetween

@NotNull
@Support
@NotNull BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> notBetween(T1 minValue1,
                                                                                                                                                                                       T2 minValue2,
                                                                                                                                                                                       T3 minValue3,
                                                                                                                                                                                       T4 minValue4,
                                                                                                                                                                                       T5 minValue5,
                                                                                                                                                                                       T6 minValue6,
                                                                                                                                                                                       T7 minValue7,
                                                                                                                                                                                       T8 minValue8,
                                                                                                                                                                                       T9 minValue9,
                                                                                                                                                                                       T10 minValue10,
                                                                                                                                                                                       T11 minValue11,
                                                                                                                                                                                       T12 minValue12,
                                                                                                                                                                                       T13 minValue13,
                                                                                                                                                                                       T14 minValue14,
                                                                                                                                                                                       T15 minValue15,
                                                                                                                                                                                       T16 minValue16)

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

See Also:

between(Row16, Row16)

notBetween

@NotNull
@Support
@NotNull BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> 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,
                                                                                                                                                                                       Field<T11> minValue11,
                                                                                                                                                                                       Field<T12> minValue12,
                                                                                                                                                                                       Field<T13> minValue13,
                                                                                                                                                                                       Field<T14> minValue14,
                                                                                                                                                                                       Field<T15> minValue15,
                                                                                                                                                                                       Field<T16> minValue16)

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

See Also:

notBetween(Row16, Row16)

notBetween

@NotNull
@Support
@NotNull BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> notBetween(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> minValue)

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

See Also:

notBetween(Row16, Row16)

notBetween

@NotNull
@Support
@NotNull BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> notBetween(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> minValue)

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

See Also:

notBetween(Row16, Row16)

notBetween

@NotNull
@Support
@NotNull Condition notBetween(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> minValue,
                              Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> 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 < B OR A > C for those SQL dialects that do not properly support the BETWEEN predicate for row value expressions

notBetween

@NotNull
@Support
@NotNull Condition notBetween(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> minValue,
                              Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> 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(Row16, Row16)

notBetweenSymmetric

@NotNull
@Support
@NotNull BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> notBetweenSymmetric(T1 minValue1,
                                                                                                                                                                                                T2 minValue2,
                                                                                                                                                                                                T3 minValue3,
                                                                                                                                                                                                T4 minValue4,
                                                                                                                                                                                                T5 minValue5,
                                                                                                                                                                                                T6 minValue6,
                                                                                                                                                                                                T7 minValue7,
                                                                                                                                                                                                T8 minValue8,
                                                                                                                                                                                                T9 minValue9,
                                                                                                                                                                                                T10 minValue10,
                                                                                                                                                                                                T11 minValue11,
                                                                                                                                                                                                T12 minValue12,
                                                                                                                                                                                                T13 minValue13,
                                                                                                                                                                                                T14 minValue14,
                                                                                                                                                                                                T15 minValue15,
                                                                                                                                                                                                T16 minValue16)

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

See Also:

notBetweenSymmetric(Row16, Row16)

notBetweenSymmetric

@NotNull
@Support
@NotNull BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> 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,
                                                                                                                                                                                                Field<T11> minValue11,
                                                                                                                                                                                                Field<T12> minValue12,
                                                                                                                                                                                                Field<T13> minValue13,
                                                                                                                                                                                                Field<T14> minValue14,
                                                                                                                                                                                                Field<T15> minValue15,
                                                                                                                                                                                                Field<T16> minValue16)

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

See Also:

notBetweenSymmetric(Row16, Row16)

notBetweenSymmetric

@NotNull
@Support
@NotNull BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> notBetweenSymmetric(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> minValue)

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

See Also:

notBetweenSymmetric(Row16, Row16)

notBetweenSymmetric

@NotNull
@Support
@NotNull BetweenAndStep16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> notBetweenSymmetric(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> minValue)

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

See Also:

notBetweenSymmetric(Row16, Row16)

notBetweenSymmetric

@NotNull
@Support
@NotNull Condition notBetweenSymmetric(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> minValue,
                                       Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> 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 < B OR 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(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> minValue,
                                       Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16> 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(Row16, Row16)

in

@NotNull
@Support
@NotNull Condition in(Collection<? extends Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> 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

in

@NotNull
@Support
@NotNull Condition in(Result<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> 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(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>... 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)

in

@NotNull
@Support
@NotNull Condition in(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>... 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 Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)

Compare this row value expression with a subselect for equality.

See Also:

in(Collection)

notIn

@NotNull
@Support
@NotNull Condition notIn(Collection<? extends Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> 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

notIn

@NotNull
@Support
@NotNull Condition notIn(Result<? extends Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> 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(Row16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>... 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)

notIn

@NotNull
@Support
@NotNull Condition notIn(Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>... 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 Record16<T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,T11,T12,T13,T14,T15,T16>> select)

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

See Also:

notIn(Collection)