Re: [sqlite] How to query data in table more than 2?

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

[sqlite] How to query data in table more than 2?

Dear all: I would like to query customer from from ooder table and only customer order more than twice. Which clause or filter should I use to filter those customer order more than twice ? Please help Best regards tom ___ sqlite-users mailing list sqli