黃楨民 <huangchen...@gmail.com> wrote: > I would like to query customer from from ooder table and only customer > order more than twice.
select CustomerId from Orders group by CustomerId having count(*) > 2; -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users