Lines Matching refs:SELECT
63 SELECT name FROM sqlite_master ORDER BY 1;
95 puts "SELECT count(*), avg(b) FROM t1 WHERE b>=$lwr AND b<$upr;"
102 puts "SELECT count(*), avg(b) FROM t1 WHERE c LIKE '%[number_name $i]%';"
122 puts "SELECT count(*), avg(b) FROM t1 WHERE b>=$lwr AND b<$upr;"
129 puts "SELECT c FROM t1 WHERE rowid=$id;"
136 puts "SELECT c FROM t1 WHERE a=$id;"
145 puts "SELECT c FROM t1 WHERE c='$c';"
193 puts {INSERT INTO t1 SELECT * FROM t2;}
201 puts {INSERT INTO t1 SELECT * FROM t2;}
215 puts {INSERT INTO t1 SELECT * FROM t2;}
217 # Select 20000 rows from the table at random.
220 SELECT rowid FROM t1 ORDER BY random() LIMIT 20000;
227 (SELECT rowid FROM t1 ORDER BY random() LIMIT 20000);
229 puts {SELECT count(*) FROM t1;}
235 (SELECT rowid FROM t1 ORDER BY random() LIMIT 20000);
237 puts {SELECT count(*) FROM t1;}
