This should do it. select region, count(*) from hosts group by region union all select 'Total, count(*) from hosts ;
On 10/3/2011 11:49 AM, James Kang wrote:
select region, count(*) from hosts group by region
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users