鞠勇鸿的技术专栏

select row_number() over (order by [ID]) as RowID,[ID] from Table1order by [ID] 

IDScore1102938475665748392表格首先是ID升序，Score降序。目标：找出累计（合计）分数超过50的最大的几个分数，select * from test where id<=(select top 1 t.id from test twhere (select SUM(score) from test t2 where t2.id<=t.id)>50...

IDScore1102938475665748392表格首先是ID升序，Score降序。select *,(select SUM(score) from test t2 where t2.id<=t.id) as sum1 from test t

select convert(varchar,cast(123123123 as money),1)