That does it. Thank you! Now, I feel a little shame and will pick up a SQL book to read.
On Oct 3, 2011, at 2:53 PM, Jim Morris <[email protected]> wrote: > > 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 >> [email protected] >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
