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