KQLite/com.kqlite.statement/CompoundStatement/except

except

abstract fun <S : KQLiteTable> except(select: () -> SelectStatement<S>): SelectStatement<S>

Appends an EXCEPT operator to the current query, returning rows from the first SELECT statement that are not present in the result set of the second SELECT statement.

The EXCEPT operator compares the result sets of two SELECT statements and returns distinct rows from the left query that are not in the right query's result. The SELECT statements being combined must have the same number of columns in their result sets with similar data types.

Example:

AllEmployees
     .select(
         AllEmployees.id,
         AllEmployees.name
     ).except {
         RetiredEmployees.select(
             RetiredEmployees.id,
             RetiredEmployees.name
         )
     }.execute(con)

This would generate SQL similar to: SELECT id, name FROM AllEmployees EXCEPT SELECT id, name FROM RetiredEmployees;

Return

A new SelectStatement representing the resulting query.

Author

MOHAMMAD AZIM ANSARI

Parameters

select

A lambda function that returns the SelectStatement whose results will be excluded from the current query's result set.

Type Parameters

The type of the KQLiteTable being queried.