SELECT column_a,column_b,COUNT(*) as num FROM TABLE GROUP BY column_a,column_b;
创新互联是一家专注于成都网站设计、网站制作与策划设计,英吉沙网站建设哪家好?创新互联做网站,专注于网站建设10多年,网设计领域的专业建站公司;建站业务涵盖:英吉沙等地区。英吉沙做网站价格咨询:028-86922220
SELECT column_a,column_b,COUNT(*) as num FROM TABLE group by column_a,column_b having count(*)>1;