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
0.4
1.73333333333333
There are two blank lines ,how can i omit the number/0 in the result,i want
only three lines as my result
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
