
 All Superinterfaces:
FieldOrRow
,QueryPart
,Row
,Serializable
public interface Row1<T1> 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 nonequality 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
All Methods Instance Methods Abstract Methods Modifier and Type Method Description @NotNull BetweenAndStep1<T1>
between(Field<T1> minValue1)
Check if this row value expression is within a range of two other row value expressions.@NotNull BetweenAndStep1<T1>
between(Record1<T1> minValue)
Check if this row value expression is within a range of two records.@NotNull Condition
between(Record1<T1> minValue, Record1<T1> maxValue)
Check if this row value expression is within a range of two records.@NotNull BetweenAndStep1<T1>
between(Row1<T1> minValue)
Check if this row value expression is within a range of two other row value expressions.@NotNull Condition
between(Row1<T1> minValue, Row1<T1> maxValue)
Check if this row value expression is within a range of two other row value expressions.@NotNull BetweenAndStep1<T1>
between(T1 minValue1)
Check if this row value expression is within a range of two other row value expressions.@NotNull BetweenAndStep1<T1>
betweenSymmetric(Field<T1> minValue1)
Check if this row value expression is within a symmetric range of two other row value expressions.@NotNull BetweenAndStep1<T1>
betweenSymmetric(Record1<T1> minValue)
Check if this row value expression is within a symmetric range of two records.@NotNull Condition
betweenSymmetric(Record1<T1> minValue, Record1<T1> maxValue)
Check if this row value expression is within a symmetric range of two records.@NotNull BetweenAndStep1<T1>
betweenSymmetric(Row1<T1> minValue)
Check if this row value expression is within a symmetric range of two other row value expressions.@NotNull Condition
betweenSymmetric(Row1<T1> minValue, Row1<T1> maxValue)
Check if this row value expression is within a symmetric range of two other row value expressions.@NotNull BetweenAndStep1<T1>
betweenSymmetric(T1 minValue1)
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)
Compare this row value expression with another row value expression using a dynamic comparator.@NotNull Condition
compare(Comparator comparator, QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect using a dynamic comparator.@NotNull Condition
compare(Comparator comparator, Record1<T1> record)
Compare this row value expression with a record using a dynamic comparator.@NotNull Condition
compare(Comparator comparator, Row1<T1> row)
Compare this row value expression with another row value expression using a dynamic comparator.@NotNull Condition
compare(Comparator comparator, Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect using a dynamic comparator.@NotNull Condition
compare(Comparator comparator, T1 t1)
Compare this row value expression with another row value expression using a dynamic comparator.@NotNull Condition
eq(Field<T1> t1)
Compare this row value expression with another row value expression for equality.@NotNull Condition
eq(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for equality.@NotNull Condition
eq(Record1<T1> record)
Compare this row value expression with a record for equality.@NotNull Condition
eq(Row1<T1> row)
Compare this row value expression with another row value expression for equality.@NotNull Condition
eq(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for equality.@NotNull Condition
eq(T1 t1)
Compare this row value expression with another row value expression for equality.@NotNull Condition
equal(Field<T1> t1)
Compare this row value expression with another row value expression for equality.@NotNull Condition
equal(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for equality.@NotNull Condition
equal(Record1<T1> record)
Compare this row value expression with a record for equality.@NotNull Condition
equal(Row1<T1> row)
Compare this row value expression with another row value expression for equality.@NotNull Condition
equal(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for equality.@NotNull Condition
equal(T1 t1)
Compare this row value expression with another row value expression for equality.@NotNull Field<T1>
field1()
Get the first field.@NotNull Condition
ge(Field<T1> t1)
Compare this row value expression with another row value expression for order.@NotNull Condition
ge(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.@NotNull Condition
ge(Record1<T1> record)
Compare this row value expression with a record for order.@NotNull Condition
ge(Row1<T1> row)
Compare this row value expression with another row value expression for order.@NotNull Condition
ge(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.@NotNull Condition
ge(T1 t1)
Compare this row value expression with another row value expression for order.@NotNull Condition
greaterOrEqual(Field<T1> t1)
Compare this row value expression with another row value expression for order.@NotNull Condition
greaterOrEqual(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.@NotNull Condition
greaterOrEqual(Record1<T1> record)
Compare this row value expression with a record for order.@NotNull Condition
greaterOrEqual(Row1<T1> row)
Compare this row value expression with another row value expression for order.@NotNull Condition
greaterOrEqual(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.@NotNull Condition
greaterOrEqual(T1 t1)
Compare this row value expression with another row value expression for order.@NotNull Condition
greaterThan(Field<T1> t1)
Compare this row value expression with another row value expression for order.@NotNull Condition
greaterThan(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.@NotNull Condition
greaterThan(Record1<T1> record)
Compare this row value expression with a record for order.@NotNull Condition
greaterThan(Row1<T1> row)
Compare this row value expression with another row value expression for order.@NotNull Condition
greaterThan(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.@NotNull Condition
greaterThan(T1 t1)
Compare this row value expression with another row value expression for order.@NotNull Condition
gt(Field<T1> t1)
Compare this row value expression with another row value expression for order.@NotNull Condition
gt(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.@NotNull Condition
gt(Record1<T1> record)
Compare this row value expression with a record for order.@NotNull Condition
gt(Row1<T1> row)
Compare this row value expression with another row value expression for order.@NotNull Condition
gt(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.@NotNull Condition
gt(T1 t1)
Compare this row value expression with another row value expression for order.@NotNull Condition
in(Collection<? extends Row1<T1>> rows)
Compare this row value expression with a set of row value expressions for equality.@NotNull Condition
in(Record1<T1>... record)
Compare this row value expression with a set of records for equality.@NotNull Condition
in(Result<? extends Record1<T1>> result)
Compare this row value expression with a set of records for equality.@NotNull Condition
in(Row1<T1>... rows)
Compare this row value expression with a set of row value expressions for equality.@NotNull Condition
in(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for equality.@NotNull Condition
isDistinctFrom(Field<T1> t1)
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
isDistinctFrom(Record1<T1> record)
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
isDistinctFrom(Row1<T1> row)
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
isDistinctFrom(Select<? extends Record1<T1>> select)
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
isDistinctFrom(T1 t1)
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
isNotDistinctFrom(Field<T1> t1)
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
isNotDistinctFrom(Record1<T1> record)
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
isNotDistinctFrom(Row1<T1> row)
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
isNotDistinctFrom(Select<? extends Record1<T1>> select)
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
isNotDistinctFrom(T1 t1)
Compare this row value expression with another row value expression for distinctness.@NotNull Condition
le(Field<T1> t1)
Compare this row value expression with another row value expression for order.@NotNull Condition
le(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.@NotNull Condition
le(Record1<T1> record)
Compare this row value expression with a record for order.@NotNull Condition
le(Row1<T1> row)
Compare this row value expression with another row value expression for order.@NotNull Condition
le(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.@NotNull Condition
le(T1 t1)
Compare this row value expression with another row value expression for order.@NotNull Condition
lessOrEqual(Field<T1> t1)
Compare this row value expression with another row value expression for order.@NotNull Condition
lessOrEqual(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.@NotNull Condition
lessOrEqual(Record1<T1> record)
Compare this row value expression with a record for order.@NotNull Condition
lessOrEqual(Row1<T1> row)
Compare this row value expression with another row value expression for order.@NotNull Condition
lessOrEqual(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.@NotNull Condition
lessOrEqual(T1 t1)
Compare this row value expression with another row value expression for order.@NotNull Condition
lessThan(Field<T1> t1)
Compare this row value expression with another row value expression for order.@NotNull Condition
lessThan(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.@NotNull Condition
lessThan(Record1<T1> record)
Compare this row value expression with a record for order.@NotNull Condition
lessThan(Row1<T1> row)
Compare this row value expression with another row value expression for order.@NotNull Condition
lessThan(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.@NotNull Condition
lessThan(T1 t1)
Compare this row value expression with another row value expression for order.@NotNull Condition
lt(Field<T1> t1)
Compare this row value expression with another row value expression for order.@NotNull Condition
lt(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.@NotNull Condition
lt(Record1<T1> record)
Compare this row value expression with a record for order.@NotNull Condition
lt(Row1<T1> row)
Compare this row value expression with another row value expression for order.@NotNull Condition
lt(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.@NotNull Condition
lt(T1 t1)
Compare this row value expression with another row value expression for order.@NotNull Condition
ne(Field<T1> t1)
Compare this row value expression with another row value expression for nonequality.@NotNull Condition
ne(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for nonequality.@NotNull Condition
ne(Record1<T1> record)
Compare this row value expression with a record for nonequality.@NotNull Condition
ne(Row1<T1> row)
Compare this row value expression with another row value expression for nonequality.@NotNull Condition
ne(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for nonequality.@NotNull Condition
ne(T1 t1)
Compare this row value expression with another row value expression for nonequality.@NotNull BetweenAndStep1<T1>
notBetween(Field<T1> minValue1)
Check if this row value expression is not within a range of two other row value expressions.@NotNull BetweenAndStep1<T1>
notBetween(Record1<T1> minValue)
Check if this row value expression is within a range of two records.@NotNull Condition
notBetween(Record1<T1> minValue, Record1<T1> maxValue)
Check if this row value expression is within a range of two records.@NotNull BetweenAndStep1<T1>
notBetween(Row1<T1> minValue)
Check if this row value expression is not within a range of two other row value expressions.@NotNull Condition
notBetween(Row1<T1> minValue, Row1<T1> maxValue)
Check if this row value expression is not within a range of two other row value expressions.@NotNull BetweenAndStep1<T1>
notBetween(T1 minValue1)
Check if this row value expression is not within a range of two other row value expressions.@NotNull BetweenAndStep1<T1>
notBetweenSymmetric(Field<T1> minValue1)
Check if this row value expression is not within a symmetric range of two other row value expressions.@NotNull BetweenAndStep1<T1>
notBetweenSymmetric(Record1<T1> minValue)
Check if this row value expression is not within a symmetric range of two records.@NotNull Condition
notBetweenSymmetric(Record1<T1> minValue, Record1<T1> maxValue)
Check if this row value expression is not within a symmetric range of two records.@NotNull BetweenAndStep1<T1>
notBetweenSymmetric(Row1<T1> minValue)
Check if this row value expression is not within a symmetric range of two other row value expressions.@NotNull Condition
notBetweenSymmetric(Row1<T1> minValue, Row1<T1> maxValue)
Check if this row value expression is not within a symmetric range of two other row value expressions.@NotNull BetweenAndStep1<T1>
notBetweenSymmetric(T1 minValue1)
Check if this row value expression is not within a symmetric range of two other row value expressions.@NotNull Condition
notEqual(Field<T1> t1)
Compare this row value expression with another row value expression for nonequality.@NotNull Condition
notEqual(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for nonequality.@NotNull Condition
notEqual(Record1<T1> record)
Compare this row value expression with a record for nonequality@NotNull Condition
notEqual(Row1<T1> row)
Compare this row value expression with another row value expression for nonequality.@NotNull Condition
notEqual(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for nonequality.@NotNull Condition
notEqual(T1 t1)
Compare this row value expression with another row value expression for.@NotNull Condition
notIn(Collection<? extends Row1<T1>> rows)
Compare this row value expression with a set of row value expressions for equality.@NotNull Condition
notIn(Record1<T1>... record)
Compare this row value expression with a set of records for nonequality.@NotNull Condition
notIn(Result<? extends Record1<T1>> result)
Compare this row value expression with a set of records for equality.@NotNull Condition
notIn(Row1<T1>... rows)
Compare this row value expression with a set of row value expressions for equality.@NotNull Condition
notIn(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for nonequality.



Method Detail

compare
@NotNull @Support @NotNull Condition compare(Comparator comparator, Row1<T1> 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

compare
@NotNull @Support @NotNull Condition compare(Comparator comparator, Record1<T1> 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

compare
@NotNull @Support @NotNull Condition compare(Comparator comparator, T1 t1)
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

compare
@NotNull @Support @NotNull Condition compare(Comparator comparator, Field<T1> t1)
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

compare
@NotNull @Support @NotNull Condition compare(Comparator comparator, Select<? extends Record1<T1>> 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

compare
@NotNull @Support @NotNull Condition compare(Comparator comparator, QuantifiedSelect<? extends Record1<T1>> 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

equal
@NotNull @Support @NotNull Condition equal(Row1<T1> 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 toA = 1 AND B = 2

equal
@NotNull @Support @NotNull Condition equal(Record1<T1> record)
Compare this row value expression with a record for equality. See Also:
equal(Row1)

equal
@NotNull @Support @NotNull Condition equal(T1 t1)
Compare this row value expression with another row value expression for equality. See Also:
equal(Row1)

equal
@NotNull @Support @NotNull Condition equal(Field<T1> t1)
Compare this row value expression with another row value expression for equality. See Also:
equal(Row1)

equal
@NotNull @Support @NotNull Condition equal(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for equality. See Also:
equal(Row1)

equal
@NotNull @Support @NotNull Condition equal(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for equality.

eq
@NotNull @Support @NotNull Condition eq(Row1<T1> row)
Compare this row value expression with another row value expression for equality. See Also:
equal(Row1)

eq
@NotNull @Support @NotNull Condition eq(Record1<T1> record)
Compare this row value expression with a record for equality. See Also:
equal(Row1)

eq
@NotNull @Support @NotNull Condition eq(T1 t1)
Compare this row value expression with another row value expression for equality. See Also:
equal(Row1)

eq
@NotNull @Support @NotNull Condition eq(Field<T1> t1)
Compare this row value expression with another row value expression for equality. See Also:
equal(Row1)

eq
@NotNull @Support @NotNull Condition eq(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for equality. See Also:
equal(Row1)

eq
@NotNull @Support @NotNull Condition eq(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for equality.

notEqual
@NotNull @Support @NotNull Condition notEqual(Row1<T1> row)
Compare this row value expression with another row value expression for nonequality.Row nonequality comparison predicates can be emulated in those databases that do not support such predicates natively:
(A, B) <> (1, 2)
is equivalent toNOT(A = 1 AND B = 2)

notEqual
@NotNull @Support @NotNull Condition notEqual(Record1<T1> record)
Compare this row value expression with a record for nonequality See Also:
notEqual(Row1)

notEqual
@NotNull @Support @NotNull Condition notEqual(T1 t1)
Compare this row value expression with another row value expression for. nonequality See Also:
notEqual(Row1)

notEqual
@NotNull @Support @NotNull Condition notEqual(Field<T1> t1)
Compare this row value expression with another row value expression for nonequality. See Also:
notEqual(Row1)

notEqual
@NotNull @Support @NotNull Condition notEqual(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for nonequality. See Also:
notEqual(Row1)

notEqual
@NotNull @Support @NotNull Condition notEqual(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for nonequality.

ne
@NotNull @Support @NotNull Condition ne(Row1<T1> row)
Compare this row value expression with another row value expression for nonequality. See Also:
notEqual(Row1)

ne
@NotNull @Support @NotNull Condition ne(Record1<T1> record)
Compare this row value expression with a record for nonequality. See Also:
notEqual(Row1)

ne
@NotNull @Support @NotNull Condition ne(T1 t1)
Compare this row value expression with another row value expression for nonequality. See Also:
notEqual(Row1)

ne
@NotNull @Support @NotNull Condition ne(Field<T1> t1)
Compare this row value expression with another row value expression for nonequality. See Also:
notEqual(Row1)

ne
@NotNull @Support @NotNull Condition ne(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for nonequality. See Also:
notEqual(Row1)

ne
@NotNull @Support @NotNull Condition ne(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for nonequality.

isDistinctFrom
@NotNull @Support @NotNull Condition isDistinctFrom(Row1<T1> row)
Compare this row value expression with another row value expression for distinctness.

isDistinctFrom
@NotNull @Support @NotNull Condition isDistinctFrom(Record1<T1> record)
Compare this row value expression with another row value expression for distinctness.

isDistinctFrom
@NotNull @Support @NotNull Condition isDistinctFrom(T1 t1)
Compare this row value expression with another row value expression for distinctness.

isDistinctFrom
@NotNull @Support @NotNull Condition isDistinctFrom(Field<T1> t1)
Compare this row value expression with another row value expression for distinctness.

isDistinctFrom
@NotNull @Support @NotNull Condition isDistinctFrom(Select<? extends Record1<T1>> select)
Compare this row value expression with another row value expression for distinctness.

isNotDistinctFrom
@NotNull @Support @NotNull Condition isNotDistinctFrom(Row1<T1> row)
Compare this row value expression with another row value expression for distinctness.

isNotDistinctFrom
@NotNull @Support @NotNull Condition isNotDistinctFrom(Record1<T1> record)
Compare this row value expression with another row value expression for distinctness.

isNotDistinctFrom
@NotNull @Support @NotNull Condition isNotDistinctFrom(T1 t1)
Compare this row value expression with another row value expression for distinctness.

isNotDistinctFrom
@NotNull @Support @NotNull Condition isNotDistinctFrom(Field<T1> t1)
Compare this row value expression with another row value expression for distinctness.

isNotDistinctFrom
@NotNull @Support @NotNull Condition isNotDistinctFrom(Select<? extends Record1<T1>> select)
Compare this row value expression with another row value expression for distinctness.

lessThan
@NotNull @Support @NotNull Condition lessThan(Row1<T1> 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 toA < 1 OR (A = 1 AND B < 2) OR (A = 1 AND B = 2 AND C < 3)

lessThan
@NotNull @Support @NotNull Condition lessThan(Record1<T1> record)
Compare this row value expression with a record for order. See Also:
lessThan(Row1)

lessThan
@NotNull @Support @NotNull Condition lessThan(T1 t1)
Compare this row value expression with another row value expression for order. See Also:
lessThan(Row1)

lessThan
@NotNull @Support @NotNull Condition lessThan(Field<T1> t1)
Compare this row value expression with another row value expression for order. See Also:
lessThan(Row1)

lessThan
@NotNull @Support @NotNull Condition lessThan(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order. See Also:
lessThan(Row1)

lessThan
@NotNull @Support @NotNull Condition lessThan(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.

lt
@NotNull @Support @NotNull Condition lt(Row1<T1> row)
Compare this row value expression with another row value expression for order. See Also:
lessThan(Row1)

lt
@NotNull @Support @NotNull Condition lt(Record1<T1> record)
Compare this row value expression with a record for order. See Also:
lessThan(Row1)

lt
@NotNull @Support @NotNull Condition lt(T1 t1)
Compare this row value expression with another row value expression for order. See Also:
lessThan(Row1)

lt
@NotNull @Support @NotNull Condition lt(Field<T1> t1)
Compare this row value expression with another row value expression for order. See Also:
lessThan(Row1)

lt
@NotNull @Support @NotNull Condition lt(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order. See Also:
lessThan(Row1)

lt
@NotNull @Support @NotNull Condition lt(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.

lessOrEqual
@NotNull @Support @NotNull Condition lessOrEqual(Row1<T1> 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 toA < 1 OR (A = 1 AND B < 2) OR (A = 1 AND B = 2)

lessOrEqual
@NotNull @Support @NotNull Condition lessOrEqual(Record1<T1> record)
Compare this row value expression with a record for order. See Also:
lessOrEqual(Row1)

lessOrEqual
@NotNull @Support @NotNull Condition lessOrEqual(T1 t1)
Compare this row value expression with another row value expression for order. See Also:
lessOrEqual(Row1)

lessOrEqual
@NotNull @Support @NotNull Condition lessOrEqual(Field<T1> t1)
Compare this row value expression with another row value expression for order. See Also:
lessOrEqual(Row1)

lessOrEqual
@NotNull @Support @NotNull Condition lessOrEqual(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order. See Also:
lessOrEqual(Row1)

lessOrEqual
@NotNull @Support @NotNull Condition lessOrEqual(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.

le
@NotNull @Support @NotNull Condition le(Row1<T1> row)
Compare this row value expression with another row value expression for order. See Also:
lessOrEqual(Row1)

le
@NotNull @Support @NotNull Condition le(Record1<T1> record)
Compare this row value expression with a record for order. See Also:
lessOrEqual(Row1)

le
@NotNull @Support @NotNull Condition le(T1 t1)
Compare this row value expression with another row value expression for order. See Also:
lessOrEqual(Row1)

le
@NotNull @Support @NotNull Condition le(Field<T1> t1)
Compare this row value expression with another row value expression for order. See Also:
lessOrEqual(Row1)

le
@NotNull @Support @NotNull Condition le(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order. See Also:
lessOrEqual(Row1)

le
@NotNull @Support @NotNull Condition le(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.

greaterThan
@NotNull @Support @NotNull Condition greaterThan(Row1<T1> 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 toA > 1 OR (A = 1 AND B > 2) OR (A = 1 AND B = 2 AND C > 3)

greaterThan
@NotNull @Support @NotNull Condition greaterThan(Record1<T1> record)
Compare this row value expression with a record for order. See Also:
greaterThan(Row1)

greaterThan
@NotNull @Support @NotNull Condition greaterThan(T1 t1)
Compare this row value expression with another row value expression for order. See Also:
greaterThan(Row1)

greaterThan
@NotNull @Support @NotNull Condition greaterThan(Field<T1> t1)
Compare this row value expression with another row value expression for order. See Also:
greaterThan(Row1)

greaterThan
@NotNull @Support @NotNull Condition greaterThan(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order. See Also:
greaterThan(Row1)

greaterThan
@NotNull @Support @NotNull Condition greaterThan(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.

gt
@NotNull @Support @NotNull Condition gt(Row1<T1> row)
Compare this row value expression with another row value expression for order. See Also:
greaterThan(Row1)

gt
@NotNull @Support @NotNull Condition gt(Record1<T1> record)
Compare this row value expression with a record for order. See Also:
greaterThan(Row1)

gt
@NotNull @Support @NotNull Condition gt(T1 t1)
Compare this row value expression with another row value expression for order. See Also:
greaterThan(Row1)

gt
@NotNull @Support @NotNull Condition gt(Field<T1> t1)
Compare this row value expression with another row value expression for order. See Also:
greaterThan(Row1)

gt
@NotNull @Support @NotNull Condition gt(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order. See Also:
greaterThan(Row1)

gt
@NotNull @Support @NotNull Condition gt(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.

greaterOrEqual
@NotNull @Support @NotNull Condition greaterOrEqual(Row1<T1> 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 toA > 1 OR (A = 1 AND B > 2) OR (A = 1 AND B = 2)

greaterOrEqual
@NotNull @Support @NotNull Condition greaterOrEqual(Record1<T1> record)
Compare this row value expression with a record for order. See Also:
greaterOrEqual(Row1)

greaterOrEqual
@NotNull @Support @NotNull Condition greaterOrEqual(T1 t1)
Compare this row value expression with another row value expression for order. See Also:
greaterOrEqual(Row1)

greaterOrEqual
@NotNull @Support @NotNull Condition greaterOrEqual(Field<T1> t1)
Compare this row value expression with another row value expression for order. See Also:
greaterOrEqual(Row1)

greaterOrEqual
@NotNull @Support @NotNull Condition greaterOrEqual(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order. See Also:
greaterOrEqual(Row1)

greaterOrEqual
@NotNull @Support @NotNull Condition greaterOrEqual(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.

ge
@NotNull @Support @NotNull Condition ge(Row1<T1> row)
Compare this row value expression with another row value expression for order. See Also:
greaterOrEqual(Row1)

ge
@NotNull @Support @NotNull Condition ge(Record1<T1> record)
Compare this row value expression with a record for order. See Also:
greaterOrEqual(Row1)

ge
@NotNull @Support @NotNull Condition ge(T1 t1)
Compare this row value expression with another row value expression for order. See Also:
greaterOrEqual(Row1)

ge
@NotNull @Support @NotNull Condition ge(Field<T1> t1)
Compare this row value expression with another row value expression for order. See Also:
greaterOrEqual(Row1)

ge
@NotNull @Support @NotNull Condition ge(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order. See Also:
greaterOrEqual(Row1)

ge
@NotNull @Support @NotNull Condition ge(QuantifiedSelect<? extends Record1<T1>> select)
Compare this row value expression with a subselect for order.

between
@NotNull @Support @NotNull BetweenAndStep1<T1> between(T1 minValue1)
Check if this row value expression is within a range of two other row value expressions. See Also:
between(Row1, Row1)

between
@NotNull @Support @NotNull BetweenAndStep1<T1> between(Field<T1> minValue1)
Check if this row value expression is within a range of two other row value expressions. See Also:
between(Row1, Row1)

between
@NotNull @Support @NotNull BetweenAndStep1<T1> between(Row1<T1> minValue)
Check if this row value expression is within a range of two other row value expressions. See Also:
between(Row1, Row1)

between
@NotNull @Support @NotNull BetweenAndStep1<T1> between(Record1<T1> minValue)
Check if this row value expression is within a range of two records. See Also:
between(Row1, Row1)

between
@NotNull @Support @NotNull Condition between(Row1<T1> minValue, Row1<T1> 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 expressionA >= B AND A <= C
for those SQL dialects that do not properly support theBETWEEN
predicate for row value expressions

between
@NotNull @Support @NotNull Condition between(Record1<T1> minValue, Record1<T1> 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(Row1, Row1)

betweenSymmetric
@NotNull @Support @NotNull BetweenAndStep1<T1> betweenSymmetric(T1 minValue1)
Check if this row value expression is within a symmetric range of two other row value expressions. See Also:
betweenSymmetric(Row1, Row1)

betweenSymmetric
@NotNull @Support @NotNull BetweenAndStep1<T1> betweenSymmetric(Field<T1> minValue1)
Check if this row value expression is within a symmetric range of two other row value expressions. See Also:
betweenSymmetric(Row1, Row1)

betweenSymmetric
@NotNull @Support @NotNull BetweenAndStep1<T1> betweenSymmetric(Row1<T1> minValue)
Check if this row value expression is within a symmetric range of two other row value expressions. See Also:
betweenSymmetric(Row1, Row1)

betweenSymmetric
@NotNull @Support @NotNull BetweenAndStep1<T1> betweenSymmetric(Record1<T1> minValue)
Check if this row value expression is within a symmetric range of two records. See Also:
betweenSymmetric(Row1, Row1)

betweenSymmetric
@NotNull @Support @NotNull Condition betweenSymmetric(Row1<T1> minValue, Row1<T1> 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 theBETWEEN
predicate for row value expressions

betweenSymmetric
@NotNull @Support @NotNull Condition betweenSymmetric(Record1<T1> minValue, Record1<T1> 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(Row1, Row1)

notBetween
@NotNull @Support @NotNull BetweenAndStep1<T1> notBetween(T1 minValue1)
Check if this row value expression is not within a range of two other row value expressions. See Also:
between(Row1, Row1)

notBetween
@NotNull @Support @NotNull BetweenAndStep1<T1> notBetween(Field<T1> minValue1)
Check if this row value expression is not within a range of two other row value expressions. See Also:
notBetween(Row1, Row1)

notBetween
@NotNull @Support @NotNull BetweenAndStep1<T1> notBetween(Row1<T1> minValue)
Check if this row value expression is not within a range of two other row value expressions. See Also:
notBetween(Row1, Row1)

notBetween
@NotNull @Support @NotNull BetweenAndStep1<T1> notBetween(Record1<T1> minValue)
Check if this row value expression is within a range of two records. See Also:
notBetween(Row1, Row1)

notBetween
@NotNull @Support @NotNull Condition notBetween(Row1<T1> minValue, Row1<T1> 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 expressionA < B OR A > C
for those SQL dialects that do not properly support theBETWEEN
predicate for row value expressions

notBetween
@NotNull @Support @NotNull Condition notBetween(Record1<T1> minValue, Record1<T1> 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(Row1, Row1)

notBetweenSymmetric
@NotNull @Support @NotNull BetweenAndStep1<T1> notBetweenSymmetric(T1 minValue1)
Check if this row value expression is not within a symmetric range of two other row value expressions. See Also:
notBetweenSymmetric(Row1, Row1)

notBetweenSymmetric
@NotNull @Support @NotNull BetweenAndStep1<T1> notBetweenSymmetric(Field<T1> minValue1)
Check if this row value expression is not within a symmetric range of two other row value expressions. See Also:
notBetweenSymmetric(Row1, Row1)

notBetweenSymmetric
@NotNull @Support @NotNull BetweenAndStep1<T1> notBetweenSymmetric(Row1<T1> minValue)
Check if this row value expression is not within a symmetric range of two other row value expressions. See Also:
notBetweenSymmetric(Row1, Row1)

notBetweenSymmetric
@NotNull @Support @NotNull BetweenAndStep1<T1> notBetweenSymmetric(Record1<T1> minValue)
Check if this row value expression is not within a symmetric range of two records. See Also:
notBetweenSymmetric(Row1, Row1)

notBetweenSymmetric
@NotNull @Support @NotNull Condition notBetweenSymmetric(Row1<T1> minValue, Row1<T1> 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 theBETWEEN
predicate for row value expressions

notBetweenSymmetric
@NotNull @Support @NotNull Condition notBetweenSymmetric(Record1<T1> minValue, Record1<T1> 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(Row1, Row1)

in
@NotNull @Support @NotNull Condition in(Collection<? extends Row1<T1>> 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 arbitrarylength
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 useSettings.isInListPadding()
to produce less distinct SQL strings (see also [#5600]), or you could avoidIN
lists, and replace them with:IN
predicates on temporary tablesIN
predicates on unnested array bind variables

in
@NotNull @Support @NotNull Condition in(Result<? extends Record1<T1>> 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 arbitrarylength
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 useSettings.isInListPadding()
to produce less distinct SQL strings (see also [#5600]), or you could avoidIN
lists, and replace them with:IN
predicates on temporary tablesIN
predicates on unnested array bind variables

in
@NotNull @Support @NotNull Condition in(Row1<T1>... rows)
Compare this row value expression with a set of row value expressions for equality.Note that generating dynamic SQL with arbitrarylength
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 useSettings.isInListPadding()
to produce less distinct SQL strings (see also [#5600]), or you could avoidIN
lists, and replace them with:IN
predicates on temporary tablesIN
predicates on unnested array bind variables
 See Also:
in(Collection)

in
@NotNull @Support @NotNull Condition in(Record1<T1>... record)
Compare this row value expression with a set of records for equality.Note that generating dynamic SQL with arbitrarylength
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 useSettings.isInListPadding()
to produce less distinct SQL strings (see also [#5600]), or you could avoidIN
lists, and replace them with:IN
predicates on temporary tablesIN
predicates on unnested array bind variables
 See Also:
in(Collection)

in
@NotNull @Support @NotNull Condition in(Select<? extends Record1<T1>> select)
Compare this row value expression with a subselect for equality. See Also:
in(Collection)

notIn
@NotNull @Support @NotNull Condition notIn(Collection<? extends Row1<T1>> 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 toNOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4)))
, which is equivalent toNOT((A = 1 AND B = 2) OR (A = 3 AND B = 4))
Note that generating dynamic SQL with arbitrarylength
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 useSettings.isInListPadding()
to produce less distinct SQL strings (see also [#5600]), or you could avoidIN
lists, and replace them with:NOT IN
predicates on temporary tablesNOT IN
predicates on unnested array bind variables

notIn
@NotNull @Support @NotNull Condition notIn(Result<? extends Record1<T1>> 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 toNOT(((A, B) = (1, 2)) OR ((A, B) = (3, 4)))
, which is equivalent toNOT((A = 1 AND B = 2) OR (A = 3 AND B = 4))
Note that generating dynamic SQL with arbitrarylength
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 useSettings.isInListPadding()
to produce less distinct SQL strings (see also [#5600]), or you could avoidIN
lists, and replace them with:NOT IN
predicates on temporary tablesNOT IN
predicates on unnested array bind variables

notIn
@NotNull @Support @NotNull Condition notIn(Row1<T1>... rows)
Compare this row value expression with a set of row value expressions for equality.Note that generating dynamic SQL with arbitrarylength
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 useSettings.isInListPadding()
to produce less distinct SQL strings (see also [#5600]), or you could avoidIN
lists, and replace them with:NOT IN
predicates on temporary tablesNOT IN
predicates on unnested array bind variables
 See Also:
notIn(Collection)

notIn
@NotNull @Support @NotNull Condition notIn(Record1<T1>... record)
Compare this row value expression with a set of records for nonequality.Note that generating dynamic SQL with arbitrarylength
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 useSettings.isInListPadding()
to produce less distinct SQL strings (see also [#5600]), or you could avoidIN
lists, and replace them with:NOT IN
predicates on temporary tablesNOT IN
predicates on unnested array bind variables
 See Also:
notIn(Collection)

