DRAFT

Omnidex SQL: SELECT WHERE Clause

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) ]

Discussion

Examples

select * from trans_table where state = 'CA';
 
Back to top
dev/sql/statements/select/where.txt ยท Last modified: 2016/06/28 22:38 (external edit)