Name
EXISTS — Test if a row exists
Syntax
Description
The EXISTS
operator returns a logic value (integer
0
or 1
) depending on whether the
SELECT
statement
returns any rows. The number of columns and their values are
irrelevant. As long as the SELECT
statement returns at least one row
consisting of at least one column, the operator will return
true—even if the column value is a NULL.
Get Using SQLite now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.