select *  from 
(
select column1,count(*)
from table
group by column1
having (count(*)>1 ) 
) a, table b
where a.column1 = b.column1
and b.column2='**';