select a.grid_code as 网格区号, a.worker_id as 工作ID, a.COLLECTION_TIME as 开始时间,b.name as 姓名, a.cnts as 采集数量 from (SELECT grid_code, worker_id,collection_time, count(1) as cnts FROM poi_collection where grid_code in(3 , 6 , 31) GROUP BY grid_code, worker_id ) as a inner join poi_user b on a.worker_id=b.worker_id order by 网格区号,采集数量现在我想把查询出来的结果再做个最终的总计,应该怎么改呢,请高手指点一下。我这段SQL是要写在VB中的。
这样?
from (
select a.grid_code as 网格区号, a.worker_id as 工作ID, a.COLLECTION_TIME as 开始时间,b.name as 姓名, a.cnts as 采集数量 from (SELECT grid_code, worker_id,collection_time, count(1) as cnts FROM poi_collection where grid_code in(3 , 6 , 31) GROUP BY grid_code, worker_id ) as a inner join poi_user b on a.worker_id=b.worker_id order by 网格区号,采集数量
) as t