Show pagesource
Old revisions

This is an old revision of the document!

DRAFT

Omnidex SQL: SELECT

SELECT expression_list
    FROM data_source
    [ WHERE predicates ]
    [ GROUP BY expression_list ]
        [ HAVING predicates ]
    [ ORDER BY expression_list ]
    [ WITH options ]

Description

FROM data_source
WHERE Clause
GROUP BY Clause
HAVING Clause
WITH options
ORDER BY Clause

Syntax

Statement

Discussion

arg1
arg2

Examples

Simple

> select * from mytable

select columns

> select company, contact from mytable
 
Back to top
dev/sql/select.1259562756.txt.gz ยท Last modified: 2012/10/26 14:25 (external edit)
Sitemap Recent Changes