唐朝小秀才的博客

SELECT d.Name [商品] , c.Name [省份] , SUM(a.Numer) [总计] , SUM(CASE WHEN DATEDIFF(year, b.Birthday, GETDATE()) BETWEEN 0 AND 18 THEN Numer ELSE 0 END) '0-18岁', SUM(CASE W

DECLARE @sql VARCHAR(MAX) SET @sql = 'SELECT DISTINCT dbo.ISS_Base_Commodity.Name [商品] ,SUM(Numer) [总销量]' SELECT @sql = @sql + ' ,CAST(ROUND(CAST(SUM(CASE dbo.ISS_System_Province.Name when ''

希望给大家带来帮助，也希望大家多多鼓励！谢谢！