Re: [sqlite] how can i omit the number/0 in the result in sqlite?

On Fri, Apr 18, 2014 at 8:35 PM, 水静流深 <1248283...@qq.com> wrote: > sqlite3 test.db create table data(num1 float,num2 float); insert into > data values(1.2,3.4); insert into data values(4,0); insert into data > values(2,5); insert into data values(3,0); insert into data values(5.2,3); > sqlite> se

Re: [sqlite] how can i omit the number/0 in the result in sqlite?

On Fri, Apr 18, 2014 at 10:35 PM, 水静流深 <1248283...@qq.com> wrote: > sqlite3 test.db create table data(num1 float,num2 float); insert into > data values(1.2,3.4); insert into data values(4,0); insert into data > values(2,5); insert into data values(3,0); insert into data values(5.2,3); > sqlite> s

[sqlite] how can i omit the number/0 in the result in sqlite?

sqlite3 test.db create table data(num1 float,num2 float); insert into data values(1.2,3.4); insert into data values(4,0); insert into data values(2,5); insert into data values(3,0); insert into data values(5.2,3); sqlite> select num1/num2 from data order by num1/num2 asc; 0.352941176470588