Hi I'd be grateful for a little advice on SQL syntax, as supported by sqlite. I have a table containing, typically, around 50,000 records. Within the table one particular field will contain many occurrences of the same string value. I can produce a de-duplicated list of the values from that field using "SELECT DISTINCT", but it would be useful to have an occurrence count against each value so that, for example, the list aaaaaabbbccccccccc would produce the output aaa, 2bbb, 1ccc, 3 I know there are ways of achieving this by joining multiple views but, for my own education, I'd like to know if there is an elegant way of achieving this in a single query. Thanks Nige
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users