Home

Getting Started

Utilities

Indexing

Omnidex

Development

Tutorials

Quick Links
 

SQL Reference

SELECT Statement

Syntax

SELECT List

FROM

WHERE

GROUP BY / HAVING

ORDER BY

Criteria Conditioning

 

SQL Reference

Joins

Nested Queries

Set Operations

ON CURSOR | INSTANCE

WITH Options

Commands

Functions

Omnidex supports most of the SQL 2 standard syntax along with some Omnidex specific extensions. This section discusses exactly what is supported in each part of the select statement.

SELECT select_items

FROM from-clause

[WHERE criteria]

[GROUP BY grouping_items

[HAVING having_clause]]

ORDER BY sort_items

 

 

 

Top