hi all a table as follow: id score 2 10 3 20 5 10 3 20 2 30 2 30 how could I select the table as follow and the count can tell me: the id 2 hava 3,the id 3 have 2 the id 5 have 1. count id score 3 2 10 2 3 20 1 5 10 2 3 20 3 2 30 3 2 30 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
- [sqlite] sql Jim Wang
- Re: [sqlite] sql R Smith
- Re: [sqlite] sql nomad
- Re: [sqlite] sql avritya