oracle select非group by的字段

把group by的结果集当作一个表，然后从这里表里取数就可以了，例如：

SELECT
	D."STUDENT_AGE",
	T .TOTAL
FROM
	(
		SELECT
			A .TEACHER_ID,
			"COUNT" (*) AS "TOTAL"
		FROM
			T_TEACHER A
		LEFT JOIN T_STUDENT B ON A .TEACHER_ID = B.I_ID
		WHERE
			A .DEL_STATUS = 1
		AND B.NAME  IS NOT NULL
		GROUP BY
			A .TEACHER_ID
		ORDER BY
			A .TEACHER_ID
		) T
LEFT JOIN T_BASIC_STUDENT D ON D.I_ID = T .TEACHER_ID;