WHERE Clause

The WHERE clause specifies the filtering conditions for the records. For SELECT operations, only the records that match the filter conditions are returned.

The supported WHERE clause operators include the following:

SELECT {columns,...} FROM <table> WHERE {columns,...} 

          [ = | > | < | >= | <= | != ] 
          [ BETWEEN | LIKE | IN ] 
          [ NOT, AND, OR ] 

<value>

Example