tbl_test maybe like this: create table tbl_test(f1, f2, f3); Now, I want to get the num of records which (f1, f2) are distinct.
I try "select count(distinct f1, f2) from tbl_test", but error occur: SQL error: wrong number of arguments to function count() although, I can do like this, but I think it not very good : select count(1) from (select distinct f1, f2 from tbl_test); _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users