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
