Roger Andersson <r...@telia.com> wrote: >> Ämne: [sqlite] Why "select count(distinct f1, f2) from >> tbl_test" can not work? >> >> Now, I want to get the num of records which (f1, f2) are distinct. >> > Maybe something like > SELECT f1,f2,count(*) FROM tbl_test GROUP BY f1,f2;
That would return, for each (f1, f2) bucket, the number of records that fall into this bucket. That doesn't sound like what the OP wants. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
