Re: [sqlite] Compute percentage?

[Roger Andersson]

  On 06/29/11 01:02 PM, Mr. Puneet Kishor wrote:
> SELECT (COUNT(rowid)*100)/(SELECT COUNT(*) FROM people) * 1.00 AS percentage
> FROM people
> WHERE zip="12345";
Seems to always return .0 ?
/Roger
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users