黃楨民 <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

Reply via email to