Show pagesource
Old revisions

This is an old revision of the document!

DRAFT

Omnidex SQL: SELECT

Description

=

Syntax

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

Discussion

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

Examples

Simple

> select * from mytable

select columns

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