为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:DM8 + idea
【CPU】:
【问题描述】*:第15 行附近出现错误[-4013]:
无效的ORDER BY子句(以前是MySQL写的,现在转换成DM)
sql语句:SELECT
a.id,
COALESCE ( sum( pt.complete_percent * pt.plan_working_hours ), 0 ) AS totalNowWorkingHours,
COALESCE ( sum( pt.plan_working_hours ), 0 ) AS totalPlanWorkingHours
FROM
pm_projectinfo a
LEFT JOIN pm_project_plan pt ON a.id = pt.project_id
AND pt.is_delete = ‘0’
AND pt.is_leaf_node = ‘1’
WHERE
a.id IN ( ‘823088040e4746b2a6605e309c8e8b7e’ )
GROUP BY
a.id
ORDER BY
a.update_date DESC
这个order by 没有意义,order by的列必须在group by的列里面,或者是集函数,如:
select name,max(id) maxid from sysobjects group by name order by maxid;
select name,max(id) mid from sysobjects group by name order by name