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, \ |