Re: [sqlite] A total with a GROUP BY

2016-12-01 Thread Cecil Westerhof
2016-12-01 21:37 GMT+01:00 Igor Tandetnik : > 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

Re: [sqlite] A total with a GROUP BY

2016-12-01 Thread nomad
On Thu Dec 01, 2016 at 07:57:06PM +0100, 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

Re: [sqlite] A total with a GROUP BY

2016-12-01 Thread Igor Tandetnik
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

[sqlite] A total with a GROUP BY

2016-12-01 Thread Cecil Westerhof
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.) -- Cecil Westerhof