注册

mysql转达梦

DM_281173 2024/12/16 271 4

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:8
【操作系统】:
【CPU】:
【问题描述】*:SELECT
t.user_id,
t.emp_id,
t.emp_name,
t.org_id,
t2.label_name,
listagg( label_value,',') AS label_value FROM
t_label_biz_info t1
INNER JOIN t_label_info t2
INNER JOIN org_employee t ON t1.label_id = t2.id
AND t.emp_id = t1.biz_id
AND t1.biz_type = 2
and IF(IFNULL(?,'') !='', (t.emp_name LIKE CONCAT('%',?,'%') or t.user_id LIKE CONCAT('%',?,'%')), 1=1 ) AND t2.label_name = ? and IF(IFNULL(?,'') !='', t2.label_value = ?, 1=1 ) AND t1.tenant_id = ? GROUP BY t.emp_id limit ? 提示Caused by: dm.jdbc.driver.DMException: 第 13 行, 第 314 列[GROUP]附近出现错误:
语法分析出错

回答 0
暂无回答
扫一扫
联系客服