Minor correction: > On 5 Apr 2019, at 09:52, Lifepillar <lifepil...@icloud.com> wrote: > > select decStr(decAdd(a,60)), case dec(b) when dec(c) then 1 else 0 end from > t1; > select decStr(decAdd(a,70)), case dec(c) when dec(b) then 1 else 0 end from > t1; > […] > select count(*), count(dec(b)), decStr(decSum(b)), decStr(decAvg(b)), > decStr(decMin(b)), decStr(decMax(b)) from t1;
should be: select decStr(decAdd(a,60)), case b when c then 1 else 0 end from t1; select decStr(decAdd(a,70)), case c when b then 1 else 0 end from t1; […] select count(*), count(b), decStr(decSum(b)), decStr(decAvg(b)), decStr(decMin(b)), decStr(decMax(b)) from t1; Life. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
