https://www.omnidex.com/docs/v54/ 2026-04-29T17:59:45+0000 https://www.omnidex.com/docs/v54/ https://www.omnidex.com/docs/v54/lib/tpl/simple/images/favicon.ico text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=dev:sql:statements:select:from&rev=1467153531&do=diff Omnidex SQL: SELECT FROM Clause QuickLinks Statements Functions OdxSQL See Also: SELECT statement WHERE clause GROUP BY clause ORDER clause Description Syntax FROM table_spec [ table_alias ] [, [table_spec2 [ table_alias ] [ $omnidex ] ] [[ < LEFT | RIGHT >][ OUTER | CROSS ] ] [ JOIN table_spec2 ] [ ON table_spec1.linkfield = table_spec2.linkfield ] [ <AND | OR> NOT] table_spec.linkfield = table_spec.linkfield ] text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=dev:sql:statements:select:group_by&rev=1467153531&do=diff Omnidex SQL: SELECT GROUP_BY Clause QuickLinks Statements Functions OdxSQL See Also: SELECT statement FROM clauseWHERE clause ORDER BY clause Description Syntax GROUP BY group_by_columns [ HAVING [ left_operand operator subquery ] [ left_operand IN (subquery) ] ] Examples Column Names From the Select List text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=dev:sql:statements:select:home&rev=1467153531&do=diff QuickLinks Statements Functions OdxSQL Omnidex SQL Statement: SELECT See Also:FROM clause WHERE clause GROUP BY clause ORDER BY clause Description The Omnidex SQL Select statement is the primary statement used to query records on Omnidex enhanced data. Omnidex will automatically optimize the SELECT statement using Omnidex indexes. Syntax text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=dev:sql:statements:select:order_by&rev=1467153531&do=diff Omnidex SQL: SELECT ORDER BY Clause QuickLinks Statements Functions OdxSQL See Also: SELECT statement FROM clauseWHERE clause GROUP BY clause Description By default, Omnidex will returned selected rows in the order returned by RDBMS or by how the data is indexed. The ORDER BY clause is used to return selected rows in sorted ascending or descending order. Multiple column_specs can be specified to cause a sort within the primary sort. text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=dev:sql:statements:select:sample&rev=1467153531&do=diff Omnidex SQL: SAMPLE Function Description The SAMPLE function is part of the SQL SELECT syntax and is supported by Omnidex. See the SELECT statement for further information. text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=dev:sql:statements:select:where&rev=1467153531&do=diff Omnidex SQL: SELECT WHERE Clause QuickLinks Statements Functions OdxSQL See Also: SELECT Statement FROM clauseGROUP BY clause ORDER BY clause Description The WHERE clause can be used to specify both criteria and table join information. Syntax WHERE [ criteria_list ] [ EXISTS (subquery) ] [ IN (subquery) ]