A search condition is the criteria specified for a WHERE clause, a HAVING clause, a CHECK clause, an ON phrase in a join, or an IF expression. A search condition is also called a predicate.
Subqueries in search conditions
ALL search condition
ANY and SOME search conditions
IS DISTINCT FROM and IS NOT DISTINCT FROM search conditions
BETWEEN search condition
LIKE, REGEXP, and SIMILAR TO search conditions
IN search condition
CONTAINS search condition
EXISTS search condition
IS NULL and IS NOT NULL search conditions
Truth value search conditions
Trigger operation conditions
Explicit selectivity estimates
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|