group by 效率的问题注释那句放出来 好像就全表扫描了SQL codeselect task_code,component_code,operatoru
group by 效率的问题
注释那句放出来 好像就全表扫描了
SQL code
select task_code,component_code,operatoruser_code,sum(statistical_data) as data1 from (select task_code,component_code,operatoruser_code,statistical_datafrom T_assessdata where task_code>' ' --and operatortime >='20110301000000' and operatortime<='20110930235959'group by task_code,component_code,operatoruser_code,statistical_data)agroup by task_code,component_code,operatoruser_code