摘要: ;with test(CID,money,NewAmount) as ( SELECT Row_Number() over ( order by money ) as CID ,money ,money *0.1 as NewAmount FROM test107 ) select b.CID , SUM(a.NewAmount ) sum_money... 阅读全文
posted @ 2018-06-27 18:17 郭大侠1 阅读(192) 评论(0) 推荐(0) 编辑