This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
dev:sql:examples:home [2010/07/02 06:45] tdo |
dev:sql:examples:home [2010/07/02 06:49] tdo |
||
|---|---|---|---|
| Line 5: | Line 5: | ||
| ===== $CONTAIN Function ===== | ===== $CONTAIN Function ===== | ||
| - | SELECT FIRST_NAME FROM CUSTOMERS WHERE $CONTAINS(FIRST_NAME,'fred,'SYNONYMS=ALL_GIVEN_NAMES') | + | SELECT FIRST_NAME FROM CUSTOMERS WHERE $CONTAINS(FIRST_NAME,'fred,'SYNONYMS=ALL_GIVEN_NAMES'); |
| + | |||
| + | SELECT FIRST_NAME FROM CUSTOMERS WHERE | ||
| + | $CONTAINS(FIRST_NAME,'fred,'SYNONYMS','LIST=ALL_GIVEN_NAMES'); | ||
| + | |||
| + | SELECT FIRST_NAME FROM CUSTOMERS WHERE $CONTAINS(FIRST_NAME, | ||
| + | '(SYNONYMS(fred,"ALL_GIVEN_NAMES"))'); | ||
| - | SELECT FIRST_NAME FROM CUSTOMERS WHERE \ | ||
| - | $CONTAINS(FIRST_NAME,'fred,'SYNONYMS','LIST=ALL_GIVEN_NAMES') | ||
| ===== Qualify Statement ===== | ===== Qualify Statement ===== | ||
| Line 15: | Line 19: | ||
| QUALIFY CUSTOMERS WHERE FIRST_NAME = 'SYNONYMS(fred,,"LIST=ALL_GIVEN_NAMES")' | QUALIFY CUSTOMERS WHERE FIRST_NAME = 'SYNONYMS(fred,,"LIST=ALL_GIVEN_NAMES")' | ||
| - | SELECT FIRST_NAME FROM CUSTOMERS WHERE $CONTAINS(FIRST_NAME, \ | + | |
| - | '(SYNONYMS(fred,"ALL_GIVEN_NAMES"))') | + | |
| ===== Searches ===== | ===== Searches ===== | ||
| Example 1: Basic search | Example 1: Basic search | ||
| Line 104: | Line 107: | ||
| PRF.DESCRIPTION | PRF.DESCRIPTION | ||
| </code> | </code> | ||
| - | |||
| ===== criteria shown with a crosstab of counts by cust_since and region ===== | ===== criteria shown with a crosstab of counts by cust_since and region ===== | ||
| - | <code SQL> | + | <code> |
| select ORD.CUST_SINCE, \ | select ORD.CUST_SINCE, \ | ||
| ORD.REGION, \ | ORD.REGION, \ | ||