Lines Matching refs:select

34     select * from t1;
42     select ifnull(a+b,99) from t1;
47     select ifnull(b*c,99) from t1;
57     select ifnull(case when b<>0 then 1 else 0 end, 99) from t1;
62     select ifnull(case when not b<>0 then 1 else 0 end, 99) from t1;
67     select ifnull(case when b<>0 and c<>0 then 1 else 0 end, 99) from t1;
72     select ifnull(case when not (b<>0 and c<>0) then 1 else 0 end, 99) from t1;
77     select ifnull(case when b<>0 or c<>0 then 1 else 0 end, 99) from t1;
82     select ifnull(case when not (b<>0 or c<>0) then 1 else 0 end, 99) from t1;
87     select ifnull(case b when c then 1 else 0 end, 99) from t1;
92     select ifnull(case c when b then 1 else 0 end, 99) from t1;
100     select count(*), count(b), count(c), sum(b), sum(c), 
114 # is the same as UNKNOWN.  The WHERE clause should only select those
119     select a from t1 where b<10
124     select a from t1 where not b>10
129     select a from t1 where b<10 or c=1;
134     select a from t1 where b<10 and c=1;
139     select a from t1 where not (b<10 and c=1);
148     select distinct b from t1 order by b;
164       select b from t1 union select c from t1 order by b;
169       select b from t1 union select c from t1 order by 1;
174       select b from t1 union select c from t1 order by t1.b;
179       select b from t1 union select c from t1 order by main.t1.b;
184       select b from t1 union select c from t1 order by t1.a;
189       select b from t1 union select c from t1 order by main.t1.a;
204       select a from t2;
214       select a from t3;