[sqlite] How to get the grand total of count(*) in a select statement

[James Kang]

I have failed to answer for myself after googling extensively.
Here is my sql statement,
      select region, count(*) from hosts group by region;
And it produce,
       region count
       nyc  34
       bos 21
       was 20

My question is how to the grand total of count(*) also in one statement as
in,
       region count
       nyc 34
       bos 21
        was 20
       total 75

Thanks
Any pointer is appreciated.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users