Lines Matching refs:select

37     select * from t1;
45     select ifnull(a+b,99) from t1;
50     select ifnull(b*c,99) from t1;
60     select ifnull(case when b<>0 then 1 else 0 end, 99) from t1;
65     select ifnull(case when not b<>0 then 1 else 0 end, 99) from t1;
70     select ifnull(case when b<>0 and c<>0 then 1 else 0 end, 99) from t1;
75     select ifnull(case when not (b<>0 and c<>0) then 1 else 0 end, 99) from t1;
80     select ifnull(case when b<>0 or c<>0 then 1 else 0 end, 99) from t1;
85     select ifnull(case when not (b<>0 or c<>0) then 1 else 0 end, 99) from t1;
90     select ifnull(case b when c then 1 else 0 end, 99) from t1;
95     select ifnull(case c when b then 1 else 0 end, 99) from t1;
104     select count(*), count(b), count(c), sum(b), sum(c), 
110 # is the same as UNKNOWN.  The WHERE clause should only select those
115     select a from t1 where b<10
120     select a from t1 where not b>10
125     select a from t1 where b<10 or c=1;
130     select a from t1 where b<10 and c=1;
135     select a from t1 where not (b<10 and c=1);
144     select distinct b from t1 order by b;
153     select b from t1 union select c from t1 order by c;
166     select a from t2;
176     select a from t3;