数据源结构为：
date nums
12-11 37
12-12 59
12-13 89
希望的结构为：
date nums nums of yeseterday
12-11 37
12-12 59 37
12-13 89 59
------解决方案--------------------
- SQL code
if not object_id('tb') is null drop table tbGoCreate table tb([date] nvarchar(5),[nums] int)Insert tbselect N'12-11',37 union allselect N'12-12',59 union allselect N'12-13',89GoSelect *, (select top 1 [nums] from tb where [date]<t.[date] order by [date] desc)[nums of yeseterday]from tb t/*date nums nums of yeseterday----- ----------- ------------------12-11 37 NULL12-12 59 3712-13 89 59(3 row(s) affected)*/
------解决方案--------------------
- SQL code
if OBJECT_ID('tb') is not null drop table tbgocreate table tb( date varchar(10), nums int)insert into tbselect '12-11',37 union allselect '12-12',59 union allselect '12-13',89;with cte as( select ROW_NUMBER()over(order by date) as rn,* from tb)select a.date,a.nums,isnull(b.nums,'') as [nums of yeseterday] from cte a left join cte b on a.rn=b.rn+1order by a.date----------------date nums nums of yeseterday12-11 37 012-12 59 3712-13 89 59