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:46] 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 \ | + | SELECT FIRST_NAME FROM CUSTOMERS WHERE |
- | $CONTAINS(FIRST_NAME,'fred,'SYNONYMS','LIST=ALL_GIVEN_NAMES') | + | $CONTAINS(FIRST_NAME,'fred,'SYNONYMS','LIST=ALL_GIVEN_NAMES'); |
- | SELECT FIRST_NAME FROM CUSTOMERS WHERE $CONTAINS(FIRST_NAME, \ | + | SELECT FIRST_NAME FROM CUSTOMERS WHERE $CONTAINS(FIRST_NAME, |
- | '(SYNONYMS(fred,"ALL_GIVEN_NAMES"))') | + | '(SYNONYMS(fred,"ALL_GIVEN_NAMES"))'); |
===== Qualify Statement ===== | ===== Qualify Statement ===== | ||
Line 107: | 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, \ |