Lines Matching refs:select
35 select * from t1;
43 select ifnull(a+b,99) from t1;
48 select ifnull(b*c,99) from t1;
58 select ifnull(case when b<>0 then 1 else 0 end, 99) from t1;
63 select ifnull(case when not b<>0 then 1 else 0 end, 99) from t1;
68 select ifnull(case when b<>0 and c<>0 then 1 else 0 end, 99) from t1;
73 select ifnull(case when not (b<>0 and c<>0) then 1 else 0 end, 99) from t1;
78 select ifnull(case when b<>0 or c<>0 then 1 else 0 end, 99) from t1;
83 select ifnull(case when not (b<>0 or c<>0) then 1 else 0 end, 99) from t1;
88 select ifnull(case b when c then 1 else 0 end, 99) from t1;
93 select ifnull(case c when b then 1 else 0 end, 99) from t1;
102 select count(*), count(b), count(c), sum(b), sum(c),
108 # is the same as UNKNOWN. The WHERE clause should only select those
113 select a from t1 where b<10
118 select a from t1 where not b>10
123 select a from t1 where b<10 or c=1;
128 select a from t1 where b<10 and c=1;
133 select a from t1 where not (b<10 and c=1);
142 select distinct b from t1 order by b;
151 select b from t1 union select c from t1 order by c;
164 select a from t2;
174 select a from t3;