August 2010
Intermediate to advanced
526 pages
23h 39m
English
EXISTS — Test if a row exists
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.
Read now
Unlock full access