> Ämne: [sqlite] Why "select count(distinct f1, f2) from > tbl_test" can not work? > > 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); > Maybe something like SELECT f1,f2,count(*) FROM tbl_test GROUP BY f1,f2; /Roger
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
