This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
dev:sql:examples:home [2010/07/02 06:45] tdo |
dev:sql:examples:home [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| {{page>:top_add&nofooter&noeditbtn}} | {{page>:top_add&nofooter&noeditbtn}} | ||
| - | <html><div align="center"><span style="color:red">DRAFT</span></div></html> | ||
| ====== Omnidex SQL Examples ====== | ====== Omnidex SQL Examples ====== | ||
| {{page>:sql_bar&nofooter&noeditbtn}} | {{page>:sql_bar&nofooter&noeditbtn}} | ||
| ===== $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 18: | ||
| 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 | ||
| - | </code> | + | <code> |
| select TOP 20 PRO.COMPANY, \ | select TOP 20 PRO.COMPANY, \ | ||
| PRO.CONTACT, \ | PRO.CONTACT, \ | ||
| Line 104: | Line 106: | ||
| 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, \ | ||