select 中函数与函数查询可以，函数与字段查询就报错，这是为什么
函数：SELECT COUNT(s.KS_ID) AS nu,SUM(s.KS_ID) AS num FROM EXAM_YEAR_KS s
函数与字段：SELECT COUNT(s.KS_ID) AS nu,s.KS_ID AS num FROM EXAM_YEAR_KS s
回答 0
暂无回答
宁静致远
SELECT COUNT(s.KS_ID) AS nu,s.KS_ID AS num FROM EXAM_YEAR_KS s GROUP BY s.KS_ID;
SELECT COUNT(s.KS_ID) AS nu,s.KS_ID AS num FROM EXAM_YEAR_KS s GROUP BY s.KS_ID;