Re: how to ?? sql query

Greg Hopkins <gregho_at_mosaix.com> wrote:

>How can I code SQL to do this ??
 

>SELECT C1 FROM T WHERE COUNT(C1) = 2
>
>I started looking at GROUP BY, HAVING etc

You're looking in the right place. Try...

select c1 from t group by c1 having count(*) = 2;

--
Chuck Hamilton
chuckh_at_dvol.com

This message delivered by electronic sled dogs. WOOF!