Hi all, I have a DB i.e. like this:
table values bc temp 35 123 35 124 35 123 20 123 12 123 12 123 16 123 35 123 35 123 35 123 35 123 35 123 The value in temp (or all the other columns) is not of interest. Now I a looking for the basic concept how to count the number of rows where bc=bc_of_last_row after the last different bc. SELECT COUNT(bc) FROM values WHERE bc=35; gives me the number of all rows with bc=35, so here 8. But I am looking for 5, the number of rows after the last change of bc. Regards Matth _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users