Lines Matching refs:Select
29 # Select
101 {([Select 1])} \
102 {[Expr $c] IN ([Select 1])} \
103 {[Expr $c] NOT IN ([Select 1])} \
104 {EXISTS ([Select 1])} \
121 # "SELECT DISTINCT", "SELECT ALL" or "SELECT"
125 "SELECT DISTINCT"
126 "SELECT ALL"
127 "SELECT"
132 # Return a result set for a SELECT statement.
155 # The ::SelectDepth variable contains the number of ancestor SELECT
156 # statements (i.e. for a top level SELECT it is set to 0, for a
157 # sub-select 1, for a sub-select of a sub-select 2 etc.).
160 # SELECT statement. This tends to cause parser stack overflow (too
165 {[SelectKw] [ResultSet $nRes $::ColumnList] FROM ([Select])} \
166 {[SelectKw] [ResultSet $nRes] FROM ([Select])} \
170 FROM ([Select])
177 {[SelectKw] * FROM ([Select])} \
196 # Return a SELECT statement.
199 # returned SELECT statement returns a single column of data.
201 proc Select {{nMulti 0}} {
218 {[SimpleSelect $nMulti] UNION [Select $nMulti]} \
219 {[SimpleSelect $nMulti] UNION ALL [Select $nMulti]} \
220 {[SimpleSelect $nMulti] EXCEPT [Select $nMulti]} \
221 {[SimpleSelect $nMulti] INTERSECT [Select $nMulti]}
267 {[Select]}
317 {CREATE VIEW [Identifier] AS [Select]}