Filter

Read(466) Label: filter, where,

Syntax:

SELECT select_list

FROM T

WHERE search_condition

Parameter:

search_condition

Filtering condition on table T

Example:

SELECT CustID,CustName,Contact,ContactTitle,CityCode

FROM Customer  WHERE  ContactTitle == "Owner"

Find records where ContactTitle is Owner

SELECT CustID,CustName,Contact,ContactTitle,CityCode

FROM Customer  WHERE  ([30101,30201,50101]).contain(CityCode)

Find information of employees whose CityCode values are 30101,30201 and 50101 respectively

 

Tip:

1)  Except for the regular single-value-based judgments (greater than, less than and equal to), you can use an esProc function, like contain() used in the above sample code, in a filtering condition specified by search_condition.