Select Rows Using the where Clause

The where clause in a select statement specifies the search conditions that determine which rows are retrieved.

The general format is:
select select_list 
     from table_list 
     where search_conditions
Search conditions, or qualifications, in the where clause include:
The where keyword can also introduce:
SAP ASE does not necessarily evaluate and execute predicates in left-to-right order. Instead, SAP ASE can evaluate and execute predicates in any order. For example, for this query:
where x != 0 and y = 10 or z = 100

SAP ASE may not evaluate and execute x != 0 first.

For more information on search conditions, see the Reference Manual: Commands.

Related concepts
Joins: Retrieve Data from Several Tables
Subqueries: Queries Within Other Queries