I will use floating point as you all suggested. Thank you! Simon Slavin <[email protected]> 于2020年3月10日周二 下午3:25写道：
> On 10 Mar 2020, at 7:21am, Octopus ZHANG <[email protected]> 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 > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Yushan _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
