how to use count to compare number?

From: Liu Danyu Date: Thu, 18 Jan 2001 18:08:37 +0800 I would do the query as select maker, pc.id from table1 where pc.id 2 order by maker; dear all: I need some help from you. The dataset is as

how to use count to compare number?

dear all: I need some help from you. The dataset is as following maker pc.id a1 a2 a3 b4 b5 I need to retrieve the maker which include at least 2 pc.id. I try to write in this form, but it is error! select maker from table1 where count(pc.id) 2 group by maker. thank