simple sql question - group by having ?

I know this works

Select columna From tablea Group by columna Having count(*) > 1

But how can get columnb and columnc of the tablea table if i don't want to group by those columns?

A join? a union? Received on Mon Apr 23 2007 - 09:33:39 CDT