为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:win10
【CPU】:
【问题描述】*:不是 GROUP BY 表达式
sql语句:SELECT
projectinf0_.id AS id1_29_,
projectinf0_.CODE AS code2_29_,
projectinf0_.company_id AS company_3_29_,
projectinf0_.create_by AS create_b4_29_,
projectinf0_.create_date AS create_d5_29_,
projectinf0_.is_delete AS is_delet6_29_,
projectinf0_.office_id AS office_i7_29_,
projectinf0_.update_by AS update_b8_29_,
projectinf0_.update_date AS update_d9_29_,
projectinf0_.b1 AS b10_29_,
projectinf0_.b2 AS b11_29_,
projectinf0_.b3 AS b12_29_,
projectinf0_.b4 AS b13_29_,
projectinf0_.d1 AS d14_29_,
projectinf0_.d2 AS d15_29_,
projectinf0_.d3 AS d16_29_,
projectinf0_.d4 AS d17_29_,
projectinf0_.qa_personnel AS qa_pers18_29_,
projectinf0_.affiliation AS affilia19_29_,
projectinf0_.agreement_id AS agreeme20_29_,
projectinf0_.approvalreport AS approva21_29_,
projectinf0_.approval_status AS approva22_29_,
projectinf0_.approvefile AS approve23_29_,
projectinf0_.budgetamount AS budgeta24_29_,
projectinf0_.budget_id AS budget_25_29_,
projectinf0_.change_person AS change_26_29_,
projectinf0_.change_proc_ins_id AS change_27_29_,
projectinf0_.change_status AS change_28_29_,
projectinf0_.change_version AS change_29_29_,
projectinf0_.classify AS classif30_29_,
projectinf0_.close_time AS close_t31_29_,
projectinf0_.cm_person_charge AS cm_pers32_29_,
projectinf0_.combination AS combina33_29_,
projectinf0_.construction_purpose AS constru34_29_,
projectinf0_.contract_signing_type AS contrac35_29_,
projectinf0_.cooperative_company_principal AS coopera36_29_,
projectinf0_.create_milestone_way AS create_37_29_,
projectinf0_.customer AS custome38_29_,
projectinf0_.defect_number AS defect_39_29_,
projectinf0_.department_project_leader AS departm40_29_,
projectinf0_.description AS descrip41_29_,
projectinf0_.description2 AS descrip42_29_,
projectinf0_.director AS directo43_29_,
projectinf0_.frame_personnel_input AS frame_p44_29_,
projectinf0_.grade AS grade45_29_,
projectinf0_.implementation_model AS impleme46_29_,
projectinf0_.interacted_system AS interac47_29_,
projectinf0_.is_major_project AS is_majo48_29_,
projectinf0_.is_regulatory_unit_document AS is_regu49_29_,
projectinf0_.is_village_banks AS is_vill50_29_,
projectinf0_.main_business_department AS main_bu51_29_,
projectinf0_.manager AS manager52_29_,
projectinf0_.milepost_template_id AS milepos53_29_,
projectinf0_.milestone_change_proc_ins_id AS milesto54_29_,
projectinf0_.milestone_release_proc_inst_id AS milesto55_29_,
projectinf0_.milestone_release_status AS milesto56_29_,
projectinf0_.milestone_status AS milesto57_29_,
projectinf0_.NAME AS name58_29_,
projectinf0_.number AS number59_29_,
projectinf0_.other_business_personnel AS other_b60_29_,
projectinf0_.personal_investment AS persona61_29_,
projectinf0_.plan_enddate AS plan_en62_29_,
projectinf0_.plan_schedule AS plan_sc63_29_,
projectinf0_.plan_startdate AS plan_st64_29_,
projectinf0_.planning_attribute AS plannin65_29_,
projectinf0_.priority AS priorit66_29_,
projectinf0_.proc_ins_id AS proc_in67_29_,
projectinf0_.process_type AS process68_29_,
projectinf0_.project_cooperation_company AS project69_29_,
projectinf0_.project_date AS project70_29_,
projectinf0_.project_place AS project71_29_,
projectinf0_.project_type AS project72_29_,
projectinf0_.real_enddate AS real_en73_29_,
projectinf0_.real_fee AS real_fe74_29_,
projectinf0_.real_hour AS real_ho75_29_,
projectinf0_.real_schedule AS real_sc76_29_,
projectinf0_.real_startdate AS real_st77_29_,
projectinf0_.relevant_contract_amount AS relevan78_29_,
projectinf0_.remarks AS remarks79_29_,
projectinf0_.requirement_id AS require80_29_,
projectinf0_.risk_grade AS risk_gr81_29_,
projectinf0_.risklevel AS risklev82_29_,
projectinf0_.sale_person AS sale_pe83_29_,
projectinf0_.short_name AS short_n84_29_,
projectinf0_.STATUS AS status85_29_,
projectinf0_.strategy AS strateg86_29_,
projectinf0_.subordinate_item_number AS subordi87_29_,
projectinf0_.workload AS workloa88_29_
FROM
pm_projectinfo projectinf0_
WHERE
projectinf0_.is_delete = 0
AND ( projectinf0_.STATUS IN ( ‘1’, ‘1’, ‘1’ ) )
AND (
projectinf0_.id IN (‘1’,‘1’,‘1’,‘1’,‘1’,‘1’,‘1’,‘1’,‘1’,‘1’,‘1’,‘1’,‘1’,‘1’ )
)
GROUP BY
projectinf0_.id
ORDER BY
projectinf0_.update_date DESC
GROUP_OPT_FLAG=5修改数据库参数,重启实例生效
集函数包含一下 FIRST_VALUE(你的列)
GROUP BY
projectinf0_.id
所以只能查找group by里面的字段projectinf0_.id