select to_char( rwfpsj,"yyyy-mm-dd"),rwzt,count(*) from out_sale_task_d0906 t group by rwzt ,to_char( rwfpsj,"yyyy-mm-dd"),rwztselect to_char( rwfpsj,"yyyy-mm-dd"),rwzt,count(*)
select to_char( rwfpsj,"yyyy-mm-dd"),rwzt,count(*) from out_sale_task_d0906 t group by rwzt ,to_char( rwfpsj,"yyyy-mm-dd"),rwztselect to_char( rwfpsj,"yyyy-mm-dd"),rwzt,count(*)