I will use floating point as you all suggested. Thank you! Simon Slavin <slav...@bigfraud.org> 于2020年3月10日周二 下午3:25写道:
> On 10 Mar 2020, at 7:21am, Octopus ZHANG <zhangysh1...@gmail.com> wrote: > > > sqlite> select 99-(55/(30/57)); > > > > Should I expect it to return nothing? > > That's going in my list of annoying questions. Thank you. > > sqlite> select 99.0-(55.0/(30.0/57.0)); > -5.5 > > Now you can work out what the problem is. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Yushan _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users