That should be select 'Total', count(*) from hosts
On 10/3/2011 11:52 AM, Jim Morris wrote:
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
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
