黃楨民 <[email protected]> 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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to