摘要： select count(1) as pCount,列1,列2,列3 from Tempinner join temp1 on 条件1=条件1group by 列1,列2,列3 order by pCount desc 阅读全文