详情
-
类型:
故障
-
状态: 生产环境已更新
-
优先级:
一般
-
解决结果: 已修复
-
影响版本: 8.2.4.2
-
修复的版本: 8.2.4.2
-
标签:无
-
需求分类:实施配置
-
严重程度:一般
描述
【城投集团】统计表定义-->高级筛选，sql语句拼接有问题，多了个a
select filing_user , retention_period , year_code , date_of_creation , filing_dept , security_classification , fonds_name , fonds_code , type_code , COUNT(id) as count_id_1705042059865 from t_669_ws_ws_1738066022579277836_o o WHERE is_delete=0 and ( type_code = 'GDWS' ) and( status = 80 ) a group by filing_user , retention_period , year_code , date_of_creation , filing_dept , security_classification , fonds_name , fonds_code , type_code order by year_code ASC , security_classification ASC , filing_dept ASC , type_code ASC , retention_period ASC , fonds_name ASC , date_of_creation ASC
select filing_user , retention_period , year_code , date_of_creation , filing_dept , security_classification , fonds_name , fonds_code , type_code , COUNT(id) as count_id_1705042059865 from t_669_ws_ws_1738066022579277836_o o WHERE is_delete=0 and ( type_code = 'GDWS' ) and( status = 80 ) a group by filing_user , retention_period , year_code , date_of_creation , filing_dept , security_classification , fonds_name , fonds_code , type_code order by year_code ASC , security_classification ASC , filing_dept ASC , type_code ASC , retention_period ASC , fonds_name ASC , date_of_creation ASC
