On Fri, Apr 18, 2014 at 10:35 PM, 水静流深 <[email protected]> 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> 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 > SELECT num1/num2 FROM data WHERE num2!=0 ORDER BY num1/num2 ASC; Or: SELECT num1/num2 FROM data WHERE num1/num2 IS NOT NULL ORDER BY 1 ASC; Or variations thereof. > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
