1,需求:求停车场表中每个停车场的省内车辆和省外车辆的和
select parkId,parkName, sum(cast(case when tokenNo like ‘%豫%’ then ‘1’ else ‘0’ end as int)) as inProvice,sum(cast(case when tokenNo like ‘%豫%’ then ‘0’ else ‘1’ end as int)) as outSideProvince from [fujica].[dbo].[rpoutvehicleview] GROUP BY parkId,parkName
得出的结果是
sqlserver的分组求和
最新推荐文章于 2024-03-08 00:50:31 发布