This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
dev:sql:statements:select:home [2009/12/04 21:03] tdo |
dev:sql:statements:select:home [2012/10/26 14:28] (current) |
||
|---|---|---|---|
| Line 3: | Line 3: | ||
| ====== Omnidex SQL SELECT ====== | ====== Omnidex SQL SELECT ====== | ||
| {{page>:sql_bar&nofooter&noeditbtn}} | {{page>:sql_bar&nofooter&noeditbtn}} | ||
| + | ===== Description ===== | ||
| + | The Omnidex SQL Select statement is the primary statement used to query records on Omnidex enhanced data. | ||
| + | |||
| - | ===== Description ===== | ||
| ===== Syntax ===== | ===== Syntax ===== | ||
| Line 47: | Line 49: | ||
| <code SQL> | <code SQL> | ||
| GROUP BY group_by_columns | GROUP BY group_by_columns | ||
| - | </code> | + | HAVING [ left_operand operator subquery ] |
| - | <code SQL> | + | [ left_operaand IN (subquery) ] |
| - | HAVING [ left_operand operator subquery ] | + | |
| - | [ left_operaand IN (subquery) ] | + | |
| </code> | </code> | ||
| <code SQL> | <code SQL> | ||
| ORDER BY [column | position ] [, column | position ] | ORDER BY [column | position ] [, column | position ] | ||
| </code> | </code> | ||
| - | |||
| ===== Discussion ===== | ===== Discussion ===== | ||
| Line 61: | Line 60: | ||
| * All columns for the named tables using a syntax of: | * All columns for the named tables using a syntax of: | ||
| - | [[[environment.]database.]table.]* | + | [ [ [ environment. ] database. ] table. ] * |
| column A column, optionally qualified by a table, optionally with an alias | column A column, optionally qualified by a table, optionally with an alias | ||