SQL语句Tips

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