vaichidrewar vaichidrewar - 1 year ago 131
SQL Question

converting int to real in sqlite

Division in sqlite return integer value

sqlite> select totalUsers/totalBids from
(select (select count(*) from Bids) as totalBids ,
(select count(*) from Users) as totalUsers) A;

Can we typecast the result to get the real value of division result?

Answer Source

Just multiply one of the numbers by 1.0:

SELECT something*1.0/total FROM somewhere

That will give you floating point division instead of integer division.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download