On 12/1/2016 1:57 PM, Cecil Westerhof wrote:
At the moment I have the following code:
SELECT totalUsed, COUNT(*) AS Count
FROM tips
GROUP BY totalUsed
This shows the total number of records for every value of totalUsed.
Would it be possible to get the total number of records also. (Sum of
all the Count's.)
SELECT totalUsed, COUNT(*) AS Count FROM tips GROUP BY totalUsed
union all
SELECT null, COUNT(*) FROM tips;
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users