SELECT column_a,column_b,COUNT(*) as num FROM TABLE GROUP BY column_a,column_b;
SELECT column_a,column_b,COUNT(*) as num FROM TABLE group by column_a,column_b having count(*)>1;