Lines Matching refs:FROM

29   execsql {SELECT t1 FROM tbl1 ORDER BY t1}
39      SELECT * FROM t2;
46   execsql {SELECT length(t1) FROM tbl1 ORDER BY t1}
49   set r [catch {execsql {SELECT length(*) FROM tbl1 ORDER BY t1}} msg]
53   set r [catch {execsql {SELECT length(t1,5) FROM tbl1 ORDER BY t1}} msg]
57   execsql {SELECT length(t1), count(*) FROM tbl1 GROUP BY length(t1)
61   execsql {SELECT coalesce(length(a),-1) FROM t2}
67   execsql {SELECT substr(t1,1,2) FROM tbl1 ORDER BY t1}
70   execsql {SELECT substr(t1,2,1) FROM tbl1 ORDER BY t1}
73   execsql {SELECT substr(t1,3,3) FROM tbl1 ORDER BY t1}
76   execsql {SELECT substr(t1,-1,1) FROM tbl1 ORDER BY t1}
79   execsql {SELECT substr(t1,-1,2) FROM tbl1 ORDER BY t1}
82   execsql {SELECT substr(t1,-2,1) FROM tbl1 ORDER BY t1}
85   execsql {SELECT substr(t1,-2,2) FROM tbl1 ORDER BY t1}
88   execsql {SELECT substr(t1,-4,2) FROM tbl1 ORDER BY t1}
91   execsql {SELECT t1 FROM tbl1 ORDER BY substr(t1,2,20)}
94   execsql {SELECT substr(a,1,1) FROM t2}
97   execsql {SELECT substr(a,2,2) FROM t2}
108   execsql {DELETE FROM tbl1}
112   execsql {SELECT t1 FROM tbl1 ORDER BY t1}
115   execsql {SELECT length(t1) FROM tbl1 ORDER BY t1}
118   execsql {SELECT substr(t1,1,2) FROM tbl1 ORDER BY t1}
121   execsql {SELECT substr(t1,1,3) FROM tbl1 ORDER BY t1}
124   execsql {SELECT substr(t1,2,2) FROM tbl1 ORDER BY t1}
127   execsql {SELECT substr(t1,2,3) FROM tbl1 ORDER BY t1}
130   execsql {SELECT substr(t1,3,2) FROM tbl1 ORDER BY t1}
133   execsql {SELECT substr(t1,4,2) FROM tbl1 ORDER BY t1}
136   execsql {SELECT substr(t1,-1,1) FROM tbl1 ORDER BY t1}
139   execsql {SELECT substr(t1,-3,2) FROM tbl1 ORDER BY t1}
142   execsql {SELECT substr(t1,-4,3) FROM tbl1 ORDER BY t1}
145   execsql {DELETE FROM tbl1}
149   execsql {SELECT t1 FROM tbl1}
163   catchsql {SELECT abs(a,b) FROM t1}
166   catchsql {SELECT abs() FROM t1}
169   catchsql {SELECT abs(b) FROM t1 ORDER BY a}
172   catchsql {SELECT abs(c) FROM t1 ORDER BY a}
175   execsql {SELECT abs(a) FROM t2}
178   execsql {SELECT abs(t1) FROM tbl1}
182   catchsql {SELECT round(a,b,c) FROM t1}
185   catchsql {SELECT round(b,2) FROM t1 ORDER BY b}
188   catchsql {SELECT round(b,0) FROM t1 ORDER BY a}
191   catchsql {SELECT round(c) FROM t1 ORDER BY a}
194   catchsql {SELECT round(c,a) FROM t1 ORDER BY a}
197   catchsql {SELECT 'x' || round(c,a) || 'y' FROM t1 ORDER BY a}
200   catchsql {SELECT round() FROM t1 ORDER BY a}
203   execsql {SELECT coalesce(round(a,2),'nil') FROM t2}
206   execsql {SELECT round(t1,2) FROM tbl1}
212   execsql {SELECT upper(t1) FROM tbl1}
215   execsql {SELECT lower(upper(t1)) FROM tbl1}
218   execsql {SELECT upper(a), lower(a) FROM t2}
221   catchsql {SELECT upper(a,5) FROM t2}
224   catchsql {SELECT upper(*) FROM t2}
230   execsql {SELECT coalesce(a,'xyz') FROM t2}
233   execsql {SELECT coalesce(upper(a),'nil') FROM t2}
256     SELECT sum(a), count(a), round(avg(a),2), min(a), max(a), count(*) FROM t2;
261     SELECT max('z+'||a||'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOP') FROM t2;
266     CREATE TEMP TABLE t3 AS SELECT a FROM t2 ORDER BY a DESC;
267     SELECT min('z+'||a||'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOP') FROM t3;
272     SELECT max('z+'||a||'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOP') FROM t3;