sql中有字段为text类型的不能被group by
示例:
例如有一个字段名为 detail 类型为text,
select
cast(detail
as varchar(50)) as detail from 表1 group by
cast(detail as varchar(50))
即先将字段强转为varchar类型,在进行查询和group by