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
Explicit selectivity estimates
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|