Intersect

class Intersect(firstStatement: AbstractQuery<*>, val secondStatement: AbstractQuery<*>) : SetOperation

Represents an SQL operation that returns only the common rows from two query results, without any duplicates.

Constructors

Link copied to clipboard
constructor(firstStatement: AbstractQuery<*>, secondStatement: AbstractQuery<*>)

Properties

Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard

The SQL statement on the left-hand side of the set operator.

Link copied to clipboard
Link copied to clipboard
Link copied to clipboard

Whether the SQL statement is meant to be performed as part of a batch execution.

Link copied to clipboard
var limit: Int?
Link copied to clipboard
Link copied to clipboard

The SQL keyword representing the set operation.

Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
open override val set: FieldSet
Link copied to clipboard
open override val statement: SetOperation
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard

Functions

Link copied to clipboard
Link copied to clipboard
Link copied to clipboard
open override fun arguments(): List<List<Pair<IColumnType<*>, Any?>>>
Link copied to clipboard
Link copied to clipboard
open override fun copy(): Intersect

Returns a new SizedIterable that is a copy of the original.

Link copied to clipboard
open fun copyTo(other: SetOperation)
Link copied to clipboard
open override fun count(): Long

Returns the number of results retrieved after query execution.

Link copied to clipboard
open override fun empty(): Boolean

Returns whether any results were retrieved by query execution.

Link copied to clipboard

Returns only distinct results from this query that are NOT common to the results of other.

Link copied to clipboard
open fun execute(transaction: JdbcTransaction): ResultApi?

Executes the SQL statement directly in the provided transaction and returns the generated result, or null if either no result was retrieved or if the transaction blocked statement execution.

Link copied to clipboard

Determines the exact way that an SQL statement is executed in a transaction and applies any necessary logic before returning the result generated by the executed statement.

Link copied to clipboard
Link copied to clipboard
open fun forUpdate(option: ForUpdateOption = ForUpdateOption.ForUpdate): SizedIterable<ResultRow>

Returns a new SizedIterable with a locking read for the elements according to the rules specified by option.

Link copied to clipboard
fun groupBy(vararg columns: Expression<*>): SetOperation
Link copied to clipboard
Link copied to clipboard
Link copied to clipboard

Returns only results from this query that are common to the results of other, WITHOUT including any duplicates.

Link copied to clipboard
Link copied to clipboard
open operator override fun iterator(): Iterator<ResultRow>
Link copied to clipboard
open override fun limit(count: Int): SetOperation

Returns a new SizedIterable containing only count elements.

Link copied to clipboard
infix fun <T, R> SizedIterable<T>.mapLazy(f: (T) -> R): SizedIterable<R>

Returns a SizedIterable containing the lazily evaluated results of applying the function f to each original element.

Link copied to clipboard

Returns a new SizedIterable without any locking read for the elements.

Link copied to clipboard
open override fun offset(start: Long): SetOperation

Returns a new SizedIterable containing only elements starting from the specified start.

Link copied to clipboard
open override fun orderBy(vararg order: Pair<Expression<*>, SortOrder>): SetOperation

Returns a new SizedIterable with the elements sorted according to the specified expression order.

fun orderBy(column: Expression<*>, order: SortOrder = SortOrder.ASC): SetOperation
Link copied to clipboard

Uses a transaction connection and an sql string representation to return a precompiled SQL statement, stored as an implementation of PreparedStatementApi.

Link copied to clipboard
open override fun prepareSQL(transaction: Transaction, prepared: Boolean): String
open override fun prepareSQL(builder: QueryBuilder): String
Link copied to clipboard
fun AbstractQuery<*>.union(other: Query): Union

Combines all results from this query with the results of other, WITHOUT including duplicates.

Link copied to clipboard

Combines all results from this query with the results of other, WITH duplicates included.

Link copied to clipboard
open override fun withDistinct(value: Boolean): SetOperation
Link copied to clipboard
fun withDistinctOn(vararg columns: Column<*>): SetOperation