Re: [sqlite] count duplicates in the table coloumn

On 11/12/08, baxy77bax <[EMAIL PROTECTED]> wrote: > > hi, > my question is: Is there a way to count the number of specific data in the > column of a table, for example: > > let say i have a table like this: > numbers > 1 > 2 > 2 > 3 > 4 > 4 > 4 > ... > and i would like to report my da

[sqlite] count duplicates in the table coloumn

hi, my question is: Is there a way to count the number of specific data in the column of a table, for example: let say i have a table like this: numbers 1 2 2 3 4 4 4 ... and i would like to report my data in form: numbers | count 1 | 1 2 | 2 3 | 1 4 | 3 ... so far i have been doing this by usin