A WHERE statement can be used to filter data generated from a SELECT statement.

Syntax

SELECT [ ALL | DISTINCT ]
{ * | projectItem [, projectItem ]* }
FROM tableExpression
[ WHERE booleanExpression ];
The following table describes the operators can be used in a WHERE statement.
Operator Description
= Equal to
<> Not equal to
> Greater than
>= Greater than or equal to
< Smaller than
<= Smaller than or equal to

Example

  • Test data
    Address City
    Oxford Street Beijing
    Fifth Avenue Beijing
    Changan Street Shanghai
  • Test statement
    SELECT * FROM table_a WHERE City='Beijing'
  • Test result
    Address City
    Oxford Street Beijing
    Fifth Avenue Beijing