On Wed, 29 Jun 2011 11:33:15 +0200, Roger Andersson <r...@telia.com> wrote: >SELECT (COUNT(rowid)*100)/(select count(*) from people) FROM people WHERE >zip="12345";
Thanks, that worked: SELECT COUNT(*) FROM people; 400599 SELECT COUNT(*) FROM people WHERE zip="12345"; 12521 SELECT (COUNT(rowid)*100)/(SELECT COUNT(*) FROM people) FROM people WHERE zip="12345"; 3 Is it possible to display the number with decimals instead of an integer? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
