明明有这个字段orderby的时候一直提示“[-6803]：第26行附近出现错误: 非法的参数数据”

为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:8
【操作系统】：Linux
【CPU】:8
【问题描述】*：
mysql迁移到DM，SQL报错

select
	a.id,
	case a.TYPE
		when '1' then '单项选择题'
		when '2' then '多项选择题'
		when '3' then '判断题'
		when '4' then '填空题'
		when '5' then '简答题'
		ELSE '其他'
	END as type1,
	WM_CONCAT(b.xx , ',') as xx,
	c.title,
	a.CONTENT,
	a.SOLUTION,
	a.BEIZHU,
	SUBSTRING_INDEX (a.TEACHER, '$', - 1) AS TEACHER,
	a.CTDATE,
	'修改' as "操作"
from
	SJ_BEIDA.tc_paper_info as a
	left join SJ_BEIDA.kc_tk_xx as b on a.id = b.parentid
	left join SJ_BEIDA.t_app_pxkcgl_pxkc as c on a.sskc = c.id
GROUP BY
	a.id
ORDER BY
	a.CTDATE desc

回答 0

暂无回答