0 votes
1 view
in SQL by (22.4k points)

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;

1

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

Please log in or register to answer this question.

Related questions

0 votes
0 answers
0 votes
1 answer
0 votes
1 answer
asked Jul 24 in SQL by Tech4ever (22.4k points)
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...