num art state order bold ssms inner left
- /****** Script for SelectTopNRows command from SSMS ******/
- SELECT [fdSequenceID]
- ,[fdInnerTime]
- ,[fdTime]
- ,[fdData]
- ,[fdState]
- ,[fdUpdateTime]
- ,[fdCreateTime]
- FROM [NewDBTest].[dbo].[tbDataMonthHG]
- WITHfAS
- (
- SELECTROW_NUMBER()OVER( partitionbyfdSequenceIDORDER BYfdTime)ASid,* FROM [NewDBTest].[dbo].[tbDataMonthHG]
- )
- selectt.*,
- fdRate=(cast(cast(100*((t.fdData/NULLif(d.fdData,0))-1)asnumeric(25,10))as varchar(50))+'%')--小数变百分数
- from f t
- left joinf don
- t.fdInnerTime = DateAdd(year,1,d.fdInnerTime)andt.fdSequenceID=d.fdSequenceID--同比增长
- order byfdSequenceID,idasc
sqlserver 计算同比增长
来源: http://www.bubuko.com/infodetail-2081911.html