WHERE Clause#

The Where clause is used to set filter conditions, and the query results will only contain data that meets the conditions

Syntax#

WhereClause
         ::= 'WHERE' Expression

SQL Statement Template#

SELECT select_expr [,select_expr...] FROM ... WHERE where_condition

Description#

For the standalone version, WHERE is supported in all conditions. For the cluster version, the execution modes which support this clause are shown below.

SELECT Statement Elements

Offline Mode

Online Preview Mode

Online Request Mode

Note

WHERE Clause

✓

✓

The Where clause is used to set filter conditions, and only the data that meets the conditions will be included in the query result.

Example#

Simple Condition Filtering#

sql: SELECT COL1 FROM t1 where COL1 > 10;

Complex Conditions Filtering#

sql: SELECT COL1 FROM t1 where COL1 > 10 and COL2 = 20 or COL1 =0;