Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Queries: Selecting Data from a Table

The FROM clause: specifying tables Next Page

The WHERE clause: specifying rows


The WHERE clause in a SELECT statement specifies the search conditions for exactly which rows are retrieved. The general format is:

SELECT select-list
FROM table-list
WHERE search-condition

Search conditions, also called qualifications or predicates, in the WHERE clause include the following:

For more information about search conditions, see Search conditions.


Using comparison operators in the WHERE clause
Using ranges in the WHERE clause
Using lists in the WHERE clause
Matching character strings in the WHERE clause
Character strings and quotation marks
Unknown Values: NULL
Connecting conditions with logical operators
Comparing dates in search conditions
Matching rows by sound