Quadcap Software

Quadcap Embeddable Database

Quadcap Software

Syntax

whereExpression
  :  (  "where" expression 
    |  
    ) 
  ;


WHERE clause

The WHERE clause is used to filter the rows specified by the table sources in the FROM clause. The expression in the WHERE clause is a boolean expression; any rows for which the boolean expression evaluates to true are returned.

WHERE expressions also can occur in UPDATE and DELETE statements.

Implementation Notes

  • When a SELECT expression operates against a base table, QED attempts to use an index to speed up the execution of the statement, based on the terms that appear in the WHERE clause.

    QED tries to find an index or unique constraint that matches an item in the where clause.