zhangzhenggui <zhangzheng...@126.com> wrote: > Now, I want to get the num of records which (f1, f2) are distinct. > > although, I can do like this, but I think it not very good : > select count(1) from (select distinct f1, f2 from tbl_test);
What makes you think it's "not very good"? What do you feel is the problem with this? -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
