SELECT 字段1, [随便来个名字就行] = stuff(( SELECT '/' + [年级2] FROM aa t WHERE t.老师ID = aa.老师ID FOR xml path('')) , 1 , 1 , '') FROM aa GROUP BY 老师ID
SELECT 老师ID, group_concat(年级ID separator '/')class, FROM table_name GROUP BY 老师ID