Great! You solved my problem. /Patrik On 06/23/2012 06:28 PM, giris wrote: > Hi: > > > Assuming that the column in A is (for example) named x, the query will be > > select count(*), x from A group by x > > q.v "GROUP BY" > > HTH. > > Thanks > > > ________________________________ > From: Patrik Nilsson <[email protected]> > To: General Discussion of SQLite Database <[email protected]> > Sent: Saturday, June 23, 2012 12:24 PM > Subject: [sqlite] select count > > Hi All, > > I have a table "a" which contains number like: > > 1 > 1 > 1 > 1 > 2 > 2 > 4 > > When I "select distinct * from a" I get: > 1 > 2 > 4 > > How can I get the count for each number? Like this: > 1|4 > 2|2 > 4|1 > > How do I write the needed select statement? > > Best regards, > Patrik > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >
_______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
