1、group by 中有text列时，可将字段转为varchar(8000)，再进行分组。
select ID,Name,cast(Remark as varchar(8000)) as Remark from table group by Name,cast(Remark as varchar(8000));
转载于:https://www.cnblogs.com/cynthia0706/p/11505114.html
