注册

4080 不是group by

漂泊 2024/01/18 626 4

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:windows10
【CPU】:
【问题描述】*:group by 只有一个字段,但是select有多个字段,提示不是group by
SELECT
count( 0 )
FROM
(
SELECT
sr.id,
IFNULL( p.CODE, '' ) packageName,
IFNULL( d.dept_name, '' ) deptName,
IFNULL( sr.parameter_name, '' ) parameterName,
IFNULL( sr.replace_reason, '' ) replaceReason,
IFNULL(( SELECT count( 1 ) FROM "water_frame_test".wt_file_upload_info f WHERE f.del_flag = 0 AND f.foreign_id = sr.foreign_id ), 0 ) fileCount,
sr.foreign_id foreignId
FROM
"water_frame_test".wt_standby_replacement_application_info sr
LEFT JOIN "water_frame_test".wt_package_station_mapping ps ON sr.station_id = ps.station_id
AND ps.del_flag = 0
LEFT JOIN "water_frame_test".wt_package_info p ON ps.package_id = p.id
AND p.del_flag = 0
LEFT JOIN "water_frame_test".wt_station_info s ON sr.station_id = s.id
AND s.del_flag = 0
LEFT JOIN "water_frame_test".sys_dept d ON s.maintain_company_id = d.dept_id
AND d.del_flag = 0
WHERE
sr.del_flag = 0
AND sr.station_id = 1
GROUP BY
sr.id
) table_count
image.png
image.png

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