SQL统计数量,查询多列问题解决,(因为该列没有包含在聚合函数或 GROUP BY 子句中。) select count(1) as pCount,列1,列2,列3 from Tempinner join temp1 on 条件1=条件1group by 列1,列2,列3 order by pCount desc