RowN (jOOQ 3.11.12 API)

All Superinterfaces:

FieldOrRow, QueryPart, Row, Serializable
```
@Generated(value="This class was generated using jOOQ-tools")
public interface RowN
extends Row
```
A model type for a row value expression with degree N > 22.
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.

Author:

Lukas Eder

Method Summary

All Methods Instance Methods Abstract Methods
Modifier and Type	Method and Description
`BetweenAndStepN`	`between(Field<?>... minValues)` Check if this row value expression is within a range of two other row value expressions.
`BetweenAndStepN`	`between(Object... minValues)` Check if this row value expression is within a range of two other row value expressions.
`BetweenAndStepN`	`between(Record minValue)` Check if this row value expression is within a range of two records.
`Condition`	`between(Record minValue, Record maxValue)` Check if this row value expression is within a range of two records.
`BetweenAndStepN`	`between(RowN minValue)` Check if this row value expression is within a range of two other row value expressions.
`Condition`	`between(RowN minValue, RowN maxValue)` Check if this row value expression is within a range of two other row value expressions.
`BetweenAndStepN`	`betweenSymmetric(Field<?>... minValues)` Check if this row value expression is within a symmetric range of two other row value expressions.
`BetweenAndStepN`	`betweenSymmetric(Object... minValues)` Check if this row value expression is within a symmetric range of two other row value expressions.
`BetweenAndStepN`	`betweenSymmetric(Record minValue)` Check if this row value expression is within a symmetric range of two records.
`Condition`	`betweenSymmetric(Record minValue, Record maxValue)` Check if this row value expression is within a symmetric range of two records.
`BetweenAndStepN`	`betweenSymmetric(RowN minValue)` Check if this row value expression is within a symmetric range of two other row value expressions.
`Condition`	`betweenSymmetric(RowN minValue, RowN maxValue)` Check if this row value expression is within a symmetric range of two other row value expressions.
`Condition`	`compare(Comparator comparator, Field<?>... values)` Compare this row value expression with another row value expression using a dynamic comparator.
`Condition`	`compare(Comparator comparator, Object... values)` Compare this row value expression with another row value expression using a dynamic comparator.
`Condition`	`compare(Comparator comparator, QuantifiedSelect<? extends Record> select)` Compare this row value expression with a subselect using a dynamic comparator.
`Condition`	`compare(Comparator comparator, Record record)` Compare this row value expression with a record using a dynamic comparator.
`Condition`	`compare(Comparator comparator, RowN row)` Compare this row value expression with another row value expression using a dynamic comparator.
`Condition`	`compare(Comparator comparator, Select<? extends Record> select)` Compare this row value expression with a subselect using a dynamic comparator.
`Condition`	`eq(Field<?>... values)` Compare this row value expression with another row value expression for equality.
`Condition`	`eq(Object... values)` Compare this row value expression with another row value expression for equality.
`Condition`	`eq(QuantifiedSelect<? extends Record> select)` Compare this row value expression with a subselect for equality.
`Condition`	`eq(Record record)` Compare this row value expression with a record for equality.
`Condition`	`eq(RowN row)` Compare this row value expression with another row value expression for equality.
`Condition`	`eq(Select<? extends Record> select)` Compare this row value expression with a subselect for equality.
`Condition`	`equal(Field<?>... values)` Compare this row value expression with another row value expression for equality.
`Condition`	`equal(Object... values)` Compare this row value expression with another row value expression for equality.
`Condition`	`equal(QuantifiedSelect<? extends Record> select)` Compare this row value expression with a subselect for equality.
`Condition`	`equal(Record record)` Compare this row value expression with a record for equality.
`Condition`	`equal(RowN row)` Compare this row value expression with another row value expression for equality.
`Condition`	`equal(Select<? extends Record> select)` Compare this row value expression with a subselect for equality.
`Condition`	`ge(Field<?>... values)` Compare this row value expression with another row value expression for order.
`Condition`	`ge(Object... values)` Compare this row value expression with another row value expression for order.
`Condition`	`ge(QuantifiedSelect<? extends Record> select)` Compare this row value expression with a subselect for order.
`Condition`	`ge(Record record)` Compare this row value expression with a record for order.
`Condition`	`ge(RowN row)` Compare this row value expression with another row value expression for order.
`Condition`	`ge(Select<? extends Record> select)` Compare this row value expression with a subselect for order.
`Condition`	`greaterOrEqual(Field<?>... values)` Compare this row value expression with another row value expression for order.
`Condition`	`greaterOrEqual(Object... values)` Compare this row value expression with another row value expression for order.
`Condition`	`greaterOrEqual(QuantifiedSelect<? extends Record> select)` Compare this row value expression with a subselect for order.
`Condition`	`greaterOrEqual(Record record)` Compare this row value expression with a record for order.
`Condition`	`greaterOrEqual(RowN row)` Compare this row value expression with another row value expression for order.
`Condition`	`greaterOrEqual(Select<? extends Record> select)` Compare this row value expression with a subselect for order.
`Condition`	`greaterThan(Field<?>... values)` Compare this row value expression with another row value expression for order.
`Condition`	`greaterThan(Object... values)` Compare this row value expression with another row value expression for order.
`Condition`	`greaterThan(QuantifiedSelect<? extends Record> select)` Compare this row value expression with a subselect for order.
`Condition`	`greaterThan(Record record)` Compare this row value expression with a record for order.
`Condition`	`greaterThan(RowN row)` Compare this row value expression with another row value expression for order.
`Condition`	`greaterThan(Select<? extends Record> select)` Compare this row value expression with a subselect for order.
`Condition`	`gt(Field<?>... values)` Compare this row value expression with another row value expression for order.
`Condition`	`gt(Object... values)` Compare this row value expression with another row value expression for order.
`Condition`	`gt(QuantifiedSelect<? extends Record> select)` Compare this row value expression with a subselect for order.
`Condition`	`gt(Record record)` Compare this row value expression with a record for order.
`Condition`	`gt(RowN row)` Compare this row value expression with another row value expression for order.
`Condition`	`gt(Select<? extends Record> select)` Compare this row value expression with a subselect for order.
`Condition`	`in(Collection<? extends RowN> rows)` Compare this row value expression with a set of row value expressions for equality.
`Condition`	`in(Record... record)` Compare this row value expression with a set of records for equality.
`Condition`	`in(Result<? extends Record> result)` Compare this row value expression with a set of records for equality.
`Condition`	`in(RowN... rows)` Compare this row value expression with a set of row value expressions for equality.
`Condition`	`in(Select<? extends Record> select)` Compare this row value expression with a subselect for equality.
`Condition`	`isDistinctFrom(Field<?>... values)` Compare this row value expression with another row value expression for distinctness.
`Condition`	`isDistinctFrom(Object... values)` Compare this row value expression with another row value expression for distinctness.
`Condition`	`isDistinctFrom(Record record)` Compare this row value expression with another row value expression for distinctness.
`Condition`	`isDistinctFrom(RowN row)` Compare this row value expression with another row value expression for distinctness.
`Condition`	`isNotDistinctFrom(Field<?>... values)` Compare this row value expression with another row value expression for distinctness.
`Condition`	`isNotDistinctFrom(Object... values)` Compare this row value expression with another row value expression for distinctness.
`Condition`	`isNotDistinctFrom(Record record)` Compare this row value expression with another row value expression for distinctness.
`Condition`	`isNotDistinctFrom(RowN row)` Compare this row value expression with another row value expression for distinctness.
`Condition`	`le(Field<?>... values)` Compare this row value expression with another row value expression for order.
`Condition`	`le(Object... values)` Compare this row value expression with another row value expression for order.
`Condition`	`le(QuantifiedSelect<? extends Record> select)` Compare this row value expression with a subselect for order.
`Condition`	`le(Record record)` Compare this row value expression with a record for order.
`Condition`	`le(RowN row)` Compare this row value expression with another row value expression for order.
`Condition`	`le(Select<? extends Record> select)` Compare this row value expression with a subselect for order.
`Condition`	`lessOrEqual(Field<?>... values)` Compare this row value expression with another row value expression for order.
`Condition`	`lessOrEqual(Object... values)` Compare this row value expression with another row value expression for order.
`Condition`	`lessOrEqual(QuantifiedSelect<? extends Record> select)` Compare this row value expression with a subselect for order.
`Condition`	`lessOrEqual(Record record)` Compare this row value expression with a record for order.
`Condition`	`lessOrEqual(RowN row)` Compare this row value expression with another row value expression for order.
`Condition`	`lessOrEqual(Select<? extends Record> select)` Compare this row value expression with a subselect for order.
`Condition`	`lessThan(Field<?>... values)` Compare this row value expression with another row value expression for order.
`Condition`	`lessThan(Object... values)` Compare this row value expression with another row value expression for order.
`Condition`	`lessThan(QuantifiedSelect<? extends Record> select)` Compare this row value expression with a subselect for order.
`Condition`	`lessThan(Record record)` Compare this row value expression with a record for order.
`Condition`	`lessThan(RowN row)` Compare this row value expression with another row value expression for order.
`Condition`	`lessThan(Select<? extends Record> select)` Compare this row value expression with a subselect for order.
`Condition`	`lt(Field<?>... values)` Compare this row value expression with another row value expression for order.
`Condition`	`lt(Object... values)` Compare this row value expression with another row value expression for order.
`Condition`	`lt(QuantifiedSelect<? extends Record> select)` Compare this row value expression with a subselect for order.
`Condition`	`lt(Record record)` Compare this row value expression with a record for order.
`Condition`	`lt(RowN row)` Compare this row value expression with another row value expression for order.
`Condition`	`lt(Select<? extends Record> select)` Compare this row value expression with a subselect for order.
`Condition`	`ne(Field<?>... values)` Compare this row value expression with another row value expression for non-equality.
`Condition`	`ne(Object... values)` Compare this row value expression with another row value expression for non-equality.
`Condition`	`ne(QuantifiedSelect<? extends Record> select)` Compare this row value expression with a subselect for non-equality.
`Condition`	`ne(Record record)` Compare this row value expression with a record for non-equality.
`Condition`	`ne(RowN row)` Compare this row value expression with another row value expression for non-equality.
`Condition`	`ne(Select<? extends Record> select)` Compare this row value expression with a subselect for non-equality.
`BetweenAndStepN`	`notBetween(Field<?>... minValues)` Check if this row value expression is not within a range of two other row value expressions.
`BetweenAndStepN`	`notBetween(Object... minValues)` Check if this row value expression is not within a range of two other row value expressions.
`BetweenAndStepN`	`notBetween(Record minValue)` Check if this row value expression is within a range of two records.
`Condition`	`notBetween(Record minValue, Record maxValue)` Check if this row value expression is within a range of two records.
`BetweenAndStepN`	`notBetween(RowN minValue)` Check if this row value expression is not within a range of two other row value expressions.
`Condition`	`notBetween(RowN minValue, RowN maxValue)` Check if this row value expression is not within a range of two other row value expressions.
`BetweenAndStepN`	`notBetweenSymmetric(Field<?>... minValues)` Check if this row value expression is not within a symmetric range of two other row value expressions.
`BetweenAndStepN`	`notBetweenSymmetric(Object... minValues)` Check if this row value expression is not within a symmetric range of two other row value expressions.
`BetweenAndStepN`	`notBetweenSymmetric(Record minValue)` Check if this row value expression is not within a symmetric range of two records.
`Condition`	`notBetweenSymmetric(Record minValue, Record maxValue)` Check if this row value expression is not within a symmetric range of two records.
`BetweenAndStepN`	`notBetweenSymmetric(RowN minValue)` Check if this row value expression is not within a symmetric range of two other row value expressions.
`Condition`	`notBetweenSymmetric(RowN minValue, RowN maxValue)` Check if this row value expression is not within a symmetric range of two other row value expressions.
`Condition`	`notEqual(Field<?>... values)` Compare this row value expression with another row value expression for non-equality.
`Condition`	`notEqual(Object... values)` Compare this row value expression with another row value expression for.
`Condition`	`notEqual(QuantifiedSelect<? extends Record> select)` Compare this row value expression with a subselect for non-equality.
`Condition`	`notEqual(Record record)` Compare this row value expression with a record for non-equality
`Condition`	`notEqual(RowN row)` Compare this row value expression with another row value expression for non-equality.
`Condition`	`notEqual(Select<? extends Record> select)` Compare this row value expression with a subselect for non-equality.
`Condition`	`notIn(Collection<? extends RowN> rows)` Compare this row value expression with a set of row value expressions for equality.
`Condition`	`notIn(Record... record)` Compare this row value expression with a set of records for non-equality.
`Condition`	`notIn(Result<? extends Record> result)` Compare this row value expression with a set of records for equality.
`Condition`	`notIn(RowN... rows)` Compare this row value expression with a set of row value expressions for equality.
`Condition`	`notIn(Select<? extends Record> select)` Compare this row value expression with a subselect for non-equality.

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

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

- Method Detail
  - compare
```
@Support
Condition compare(Comparator comparator,
                            RowN 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(RowN), notEqual(RowN), lessThan(RowN), lessOrEqual(RowN), greaterThan(RowN), greaterOrEqual(RowN)
  - compare
```
@Support
Condition compare(Comparator comparator,
                            Record 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(Record), notEqual(Record), lessThan(Record), lessOrEqual(Record), greaterThan(Record), greaterOrEqual(Record)
  - compare
```
@Support
Condition compare(Comparator comparator,
                            Object... values)
```
    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(RowN), notEqual(RowN), lessThan(RowN), lessOrEqual(RowN), greaterThan(RowN), greaterOrEqual(RowN)
  - compare
```
@Support
Condition compare(Comparator comparator,
                            Field<?>... values)
```
    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(RowN), notEqual(RowN), lessThan(RowN), lessOrEqual(RowN), greaterThan(RowN), greaterOrEqual(RowN)
  - compare
```
@Support
Condition compare(Comparator comparator,
                            Select<? extends Record> 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
```
@Support
Condition compare(Comparator comparator,
                            QuantifiedSelect<? extends Record> 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
```
@Support
Condition equal(RowN 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
```
@Support
Condition equal(Record record)
```
    Compare this row value expression with a record for equality.
    
    See Also:
    
    equal(RowN)
  - equal
```
@Support
Condition equal(Object... values)
```
    Compare this row value expression with another row value expression for equality.
    
    See Also:
    
    equal(RowN)
  - equal
```
@Support
Condition equal(Field<?>... values)
```
    Compare this row value expression with another row value expression for equality.
    
    See Also:
    
    equal(RowN)
  - equal
```
@Support
Condition equal(Select<? extends Record> select)
```
    Compare this row value expression with a subselect for equality.
    
    See Also:
    
    equal(RowN)
  - equal
```
@Support(value={ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,VERTICA})
Condition equal(QuantifiedSelect<? extends Record> 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
```
@Support
Condition eq(RowN row)
```
    Compare this row value expression with another row value expression for equality.
    
    See Also:
    
    equal(RowN)
  - eq
```
@Support
Condition eq(Record record)
```
    Compare this row value expression with a record for equality.
    
    See Also:
    
    equal(RowN)
  - eq
```
@Support
Condition eq(Object... values)
```
    Compare this row value expression with another row value expression for equality.
    
    See Also:
    
    equal(RowN)
  - eq
```
@Support
Condition eq(Field<?>... values)
```
    Compare this row value expression with another row value expression for equality.
    
    See Also:
    
    equal(RowN)
  - eq
```
@Support
Condition eq(Select<? extends Record> select)
```
    Compare this row value expression with a subselect for equality.
    
    See Also:
    
    equal(RowN)
  - eq
```
@Support(value={ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,VERTICA})
Condition eq(QuantifiedSelect<? extends Record> 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
```
@Support
Condition notEqual(RowN 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
```
@Support
Condition notEqual(Record record)
```
    Compare this row value expression with a record for non-equality
    
    See Also:
    
    notEqual(RowN)
  - notEqual
```
@Support
Condition notEqual(Object... values)
```
    Compare this row value expression with another row value expression for. non-equality
    
    See Also:
    
    notEqual(RowN)
  - notEqual
```
@Support
Condition notEqual(Field<?>... values)
```
    Compare this row value expression with another row value expression for non-equality.
    
    See Also:
    
    notEqual(RowN)
  - notEqual
```
@Support
Condition notEqual(Select<? extends Record> select)
```
    Compare this row value expression with a subselect for non-equality.
    
    See Also:
    
    notEqual(RowN)
  - notEqual
```
@Support(value={ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,VERTICA})
Condition notEqual(QuantifiedSelect<? extends Record> 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
```
@Support
Condition ne(RowN row)
```
    Compare this row value expression with another row value expression for non-equality.
    
    See Also:
    
    notEqual(RowN)
  - ne
```
@Support
Condition ne(Record record)
```
    Compare this row value expression with a record for non-equality.
    
    See Also:
    
    notEqual(RowN)
  - ne
```
@Support
Condition ne(Object... values)
```
    Compare this row value expression with another row value expression for non-equality.
    
    See Also:
    
    notEqual(RowN)
  - ne
```
@Support
Condition ne(Field<?>... values)
```
    Compare this row value expression with another row value expression for non-equality.
    
    See Also:
    
    notEqual(RowN)
  - ne
```
@Support
Condition ne(Select<? extends Record> select)
```
    Compare this row value expression with a subselect for non-equality.
    
    See Also:
    
    notEqual(RowN)
  - ne
```
@Support(value={ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE,VERTICA})
Condition ne(QuantifiedSelect<? extends Record> 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
```
@Support
Condition isDistinctFrom(RowN row)
```
    Compare this row value expression with another row value expression for distinctness.
  - isDistinctFrom
```
@Support
Condition isDistinctFrom(Record record)
```
    Compare this row value expression with another row value expression for distinctness.
  - isDistinctFrom
```
@Support
Condition isDistinctFrom(Object... values)
```
    Compare this row value expression with another row value expression for distinctness.
  - isDistinctFrom
```
@Support
Condition isDistinctFrom(Field<?>... values)
```
    Compare this row value expression with another row value expression for distinctness.
  - isNotDistinctFrom
```
@Support
Condition isNotDistinctFrom(RowN row)
```
    Compare this row value expression with another row value expression for distinctness.
  - isNotDistinctFrom
```
@Support
Condition isNotDistinctFrom(Record record)
```
    Compare this row value expression with another row value expression for distinctness.
  - isNotDistinctFrom
```
@Support
Condition isNotDistinctFrom(Object... values)
```
    Compare this row value expression with another row value expression for distinctness.
  - isNotDistinctFrom
```
@Support
Condition isNotDistinctFrom(Field<?>... values)
```
    Compare this row value expression with another row value expression for distinctness.
  - lessThan
```
@Support
Condition lessThan(RowN 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
```
@Support
Condition lessThan(Record record)
```
    Compare this row value expression with a record for order.
    
    See Also:
    
    lessThan(RowN)
  - lessThan
```
@Support
Condition lessThan(Object... values)
```
    Compare this row value expression with another row value expression for order.
    
    See Also:
    
    lessThan(RowN)
  - lessThan
```
@Support
Condition lessThan(Field<?>... values)
```
    Compare this row value expression with another row value expression for order.
    
    See Also:
    
    lessThan(RowN)
  - lessThan
```
@Support
Condition lessThan(Select<? extends Record> select)
```
    Compare this row value expression with a subselect for order.
    
    See Also:
    
    lessThan(RowN)
  - lessThan
```
@Support(value={ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE})
Condition lessThan(QuantifiedSelect<? extends Record> 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
```
@Support
Condition lt(RowN row)
```
    Compare this row value expression with another row value expression for order.
    
    See Also:
    
    lessThan(RowN)
  - lt
```
@Support
Condition lt(Record record)
```
    Compare this row value expression with a record for order.
    
    See Also:
    
    lessThan(RowN)
  - lt
```
@Support
Condition lt(Object... values)
```
    Compare this row value expression with another row value expression for order.
    
    See Also:
    
    lessThan(RowN)
  - lt
```
@Support
Condition lt(Field<?>... values)
```
    Compare this row value expression with another row value expression for order.
    
    See Also:
    
    lessThan(RowN)
  - lt
```
@Support
Condition lt(Select<? extends Record> select)
```
    Compare this row value expression with a subselect for order.
    
    See Also:
    
    lessThan(RowN)
  - lt
```
@Support(value={ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE})
Condition lt(QuantifiedSelect<? extends Record> 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
```
@Support
Condition lessOrEqual(RowN 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
```
@Support
Condition lessOrEqual(Record record)
```
    Compare this row value expression with a record for order.
    
    See Also:
    
    lessOrEqual(RowN)
  - lessOrEqual
```
@Support
Condition lessOrEqual(Object... values)
```
    Compare this row value expression with another row value expression for order.
    
    See Also:
    
    lessOrEqual(RowN)
  - lessOrEqual
```
@Support
Condition lessOrEqual(Field<?>... values)
```
    Compare this row value expression with another row value expression for order.
    
    See Also:
    
    lessOrEqual(RowN)
  - lessOrEqual
```
@Support
Condition lessOrEqual(Select<? extends Record> select)
```
    Compare this row value expression with a subselect for order.
    
    See Also:
    
    lessOrEqual(RowN)
  - lessOrEqual
```
@Support(value={ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE})
Condition lessOrEqual(QuantifiedSelect<? extends Record> 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
```
@Support
Condition le(RowN row)
```
    Compare this row value expression with another row value expression for order.
    
    See Also:
    
    lessOrEqual(RowN)
  - le
```
@Support
Condition le(Record record)
```
    Compare this row value expression with a record for order.
    
    See Also:
    
    lessOrEqual(RowN)
  - le
```
@Support
Condition le(Object... values)
```
    Compare this row value expression with another row value expression for order.
    
    See Also:
    
    lessOrEqual(RowN)
  - le
```
@Support
Condition le(Field<?>... values)
```
    Compare this row value expression with another row value expression for order.
    
    See Also:
    
    lessOrEqual(RowN)
  - le
```
@Support
Condition le(Select<? extends Record> select)
```
    Compare this row value expression with a subselect for order.
    
    See Also:
    
    lessOrEqual(RowN)
  - le
```
@Support(value={ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE})
Condition le(QuantifiedSelect<? extends Record> 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
```
@Support
Condition greaterThan(RowN 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
```
@Support
Condition greaterThan(Record record)
```
    Compare this row value expression with a record for order.
    
    See Also:
    
    greaterThan(RowN)
  - greaterThan
```
@Support
Condition greaterThan(Object... values)
```
    Compare this row value expression with another row value expression for order.
    
    See Also:
    
    greaterThan(RowN)
  - greaterThan
```
@Support
Condition greaterThan(Field<?>... values)
```
    Compare this row value expression with another row value expression for order.
    
    See Also:
    
    greaterThan(RowN)
  - greaterThan
```
@Support
Condition greaterThan(Select<? extends Record> select)
```
    Compare this row value expression with a subselect for order.
    
    See Also:
    
    greaterThan(RowN)
  - greaterThan
```
@Support(value={ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE})
Condition greaterThan(QuantifiedSelect<? extends Record> 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
```
@Support
Condition gt(RowN row)
```
    Compare this row value expression with another row value expression for order.
    
    See Also:
    
    greaterThan(RowN)
  - gt
```
@Support
Condition gt(Record record)
```
    Compare this row value expression with a record for order.
    
    See Also:
    
    greaterThan(RowN)
  - gt
```
@Support
Condition gt(Object... values)
```
    Compare this row value expression with another row value expression for order.
    
    See Also:
    
    greaterThan(RowN)
  - gt
```
@Support
Condition gt(Field<?>... values)
```
    Compare this row value expression with another row value expression for order.
    
    See Also:
    
    greaterThan(RowN)
  - gt
```
@Support
Condition gt(Select<? extends Record> select)
```
    Compare this row value expression with a subselect for order.
    
    See Also:
    
    greaterThan(RowN)
  - gt
```
@Support(value={ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE})
Condition gt(QuantifiedSelect<? extends Record> 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
```
@Support
Condition greaterOrEqual(RowN 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
```
@Support
Condition greaterOrEqual(Record record)
```
    Compare this row value expression with a record for order.
    
    See Also:
    
    greaterOrEqual(RowN)
  - greaterOrEqual
```
@Support
Condition greaterOrEqual(Object... values)
```
    Compare this row value expression with another row value expression for order.
    
    See Also:
    
    greaterOrEqual(RowN)
  - greaterOrEqual
```
@Support
Condition greaterOrEqual(Field<?>... values)
```
    Compare this row value expression with another row value expression for order.
    
    See Also:
    
    greaterOrEqual(RowN)
  - greaterOrEqual
```
@Support
Condition greaterOrEqual(Select<? extends Record> select)
```
    Compare this row value expression with a subselect for order.
    
    See Also:
    
    greaterOrEqual(RowN)
  - greaterOrEqual
```
@Support(value={ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE})
Condition greaterOrEqual(QuantifiedSelect<? extends Record> 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
```
@Support
Condition ge(RowN row)
```
    Compare this row value expression with another row value expression for order.
    
    See Also:
    
    greaterOrEqual(RowN)
  - ge
```
@Support
Condition ge(Record record)
```
    Compare this row value expression with a record for order.
    
    See Also:
    
    greaterOrEqual(RowN)
  - ge
```
@Support
Condition ge(Object... values)
```
    Compare this row value expression with another row value expression for order.
    
    See Also:
    
    greaterOrEqual(RowN)
  - ge
```
@Support
Condition ge(Field<?>... values)
```
    Compare this row value expression with another row value expression for order.
    
    See Also:
    
    greaterOrEqual(RowN)
  - ge
```
@Support
Condition ge(Select<? extends Record> select)
```
    Compare this row value expression with a subselect for order.
    
    See Also:
    
    greaterOrEqual(RowN)
  - ge
```
@Support(value={ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HSQLDB,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLSERVER,SYBASE})
Condition ge(QuantifiedSelect<? extends Record> 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
```
@Support
BetweenAndStepN between(Object... minValues)
```
    Check if this row value expression is within a range of two other row value expressions.
    
    See Also:
    
    between(RowN, RowN)
  - between
```
@Support
BetweenAndStepN between(Field<?>... minValues)
```
    Check if this row value expression is within a range of two other row value expressions.
    
    See Also:
    
    between(RowN, RowN)
  - between
```
@Support
BetweenAndStepN between(RowN minValue)
```
    Check if this row value expression is within a range of two other row value expressions.
    
    See Also:
    
    between(RowN, RowN)
  - between
```
@Support
BetweenAndStepN between(Record minValue)
```
    Check if this row value expression is within a range of two records.
    
    See Also:
    
    between(RowN, RowN)
  - between
```
@Support
Condition between(RowN minValue,
                            RowN 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
```
@Support
Condition between(Record minValue,
                            Record 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(RowN, RowN)
  - betweenSymmetric
```
@Support
BetweenAndStepN betweenSymmetric(Object... minValues)
```
    Check if this row value expression is within a symmetric range of two other row value expressions.
    
    See Also:
    
    betweenSymmetric(RowN, RowN)
  - betweenSymmetric
```
@Support
BetweenAndStepN betweenSymmetric(Field<?>... minValues)
```
    Check if this row value expression is within a symmetric range of two other row value expressions.
    
    See Also:
    
    betweenSymmetric(RowN, RowN)
  - betweenSymmetric
```
@Support
BetweenAndStepN betweenSymmetric(RowN minValue)
```
    Check if this row value expression is within a symmetric range of two other row value expressions.
    
    See Also:
    
    betweenSymmetric(RowN, RowN)
  - betweenSymmetric
```
@Support
BetweenAndStepN betweenSymmetric(Record minValue)
```
    Check if this row value expression is within a symmetric range of two records.
    
    See Also:
    
    betweenSymmetric(RowN, RowN)
  - betweenSymmetric
```
@Support
Condition betweenSymmetric(RowN minValue,
                                     RowN 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
```
@Support
Condition betweenSymmetric(Record minValue,
                                     Record 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(RowN, RowN)
  - notBetween
```
@Support
BetweenAndStepN notBetween(Object... minValues)
```
    Check if this row value expression is not within a range of two other row value expressions.
    
    See Also:
    
    between(RowN, RowN)
  - notBetween
```
@Support
BetweenAndStepN notBetween(Field<?>... minValues)
```
    Check if this row value expression is not within a range of two other row value expressions.
    
    See Also:
    
    notBetween(RowN, RowN)
  - notBetween
```
@Support
BetweenAndStepN notBetween(RowN minValue)
```
    Check if this row value expression is not within a range of two other row value expressions.
    
    See Also:
    
    notBetween(RowN, RowN)
  - notBetween
```
@Support
BetweenAndStepN notBetween(Record minValue)
```
    Check if this row value expression is within a range of two records.
    
    See Also:
    
    notBetween(RowN, RowN)
  - notBetween
```
@Support
Condition notBetween(RowN minValue,
                               RowN 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
```
@Support
Condition notBetween(Record minValue,
                               Record 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(RowN, RowN)
  - notBetweenSymmetric
```
@Support
BetweenAndStepN notBetweenSymmetric(Object... minValues)
```
    Check if this row value expression is not within a symmetric range of two other row value expressions.
    
    See Also:
    
    notBetweenSymmetric(RowN, RowN)
  - notBetweenSymmetric
```
@Support
BetweenAndStepN notBetweenSymmetric(Field<?>... minValues)
```
    Check if this row value expression is not within a symmetric range of two other row value expressions.
    
    See Also:
    
    notBetweenSymmetric(RowN, RowN)
  - notBetweenSymmetric
```
@Support
BetweenAndStepN notBetweenSymmetric(RowN minValue)
```
    Check if this row value expression is not within a symmetric range of two other row value expressions.
    
    See Also:
    
    notBetweenSymmetric(RowN, RowN)
  - notBetweenSymmetric
```
@Support
BetweenAndStepN notBetweenSymmetric(Record minValue)
```
    Check if this row value expression is not within a symmetric range of two records.
    
    See Also:
    
    notBetweenSymmetric(RowN, RowN)
  - notBetweenSymmetric
```
@Support
Condition notBetweenSymmetric(RowN minValue,
                                        RowN 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
```
@Support
Condition notBetweenSymmetric(Record minValue,
                                        Record 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(RowN, RowN)
  - in
```
@Support
Condition in(Collection<? extends RowN> 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
```
@Support
Condition in(Result<? extends Record> 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
```
@Support
Condition in(RowN... 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
```
@Support
Condition in(Record... 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
```
@Support
Condition in(Select<? extends Record> select)
```
    Compare this row value expression with a subselect for equality.
    
    See Also:
    
    in(Collection)
  - notIn
```
@Support
Condition notIn(Collection<? extends RowN> 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
```
@Support
Condition notIn(Result<? extends Record> 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
```
@Support
Condition notIn(RowN... 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
```
@Support
Condition notIn(Record... 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
```
@Support
Condition notIn(Select<? extends Record> select)
```
    Compare this row value expression with a subselect for non-equality.
    
    See Also:
    
    notIn(Collection)

Interface RowN

Method Summary

Methods inherited from interface org.jooq.Row

Methods inherited from interface org.jooq.QueryPart

Method Detail

compare

compare

compare

compare

compare

compare

equal

equal

equal

equal

equal

equal

eq

eq

eq

eq

eq

eq

notEqual

notEqual

notEqual

notEqual

notEqual

notEqual

ne

ne

ne

ne

ne

ne

isDistinctFrom

isDistinctFrom

isDistinctFrom

isDistinctFrom

isNotDistinctFrom

isNotDistinctFrom

isNotDistinctFrom

isNotDistinctFrom

lessThan

lessThan

lessThan

lessThan

lessThan

lessThan

lt

lt

lt

lt

lt

lt

lessOrEqual

lessOrEqual

lessOrEqual

lessOrEqual

lessOrEqual

lessOrEqual

le

le

le

le

le

le

greaterThan

greaterThan

greaterThan

greaterThan

greaterThan

greaterThan

gt

gt

gt

gt

gt

gt

greaterOrEqual