Peng Yu <[email protected]> wrote: > I use || to count distinct on multiple fields. It works for this > particular example. But I'm not sure if it is robust. Would you please > let me know if there is any better way? > > select distinct value1, value2 from test; > select count(distinct value1||value2) from test;
select count(*) from (select distinct value1, value2 from test); -- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
