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.