On 5/6/2011 10:03 AM, Matthew Jones wrote: > Given a table with multiple columns in it how do I count how many > entries there are with column A matching some value where column B is > distinct?
select count(distinct b) from a where a=10; -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users