I have the following query that produces a summary table SELECT cat, COUNT(*) AS occ, COUNT(DISTINCT tes) AS uni, COUNT(tag) AS tagged FROM rtable WHERE qu > 0 AND qu < 4 GROUP BY qu
The table would look something like 1 54 3 2 26 4 3 56 8 I want to modify the above sql query to sum the second and third columns and get a resultant table something like 1 54 3 2 26 4 3 56 8 tot 136 15 any ideas? _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
