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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
