SQL Server分組排序取數(shù)據(jù)的實(shí)現(xiàn)
作者：佚名
我們今天主要是和大家一起分享的是實(shí)現(xiàn)SQL Server分組排序之后取每組的第N行數(shù)據(jù)的實(shí)際操作步驟，以下就是文章的主要內(nèi)容描述。
以下的文章主要向大家講述的是實(shí)現(xiàn)SQL Server分組排序之后取每組的第N行數(shù)據(jù)的實(shí)際操作步驟，我們首先是以展示代碼select 的方式來(lái)引出其實(shí)際操作步驟，以下就是文章的主要內(nèi)容描述。
示例代碼select
- A.[DocNo] as [docno],
- A1.[Item_ItemCode] as [itemcode],
- A2.[LineNum] as [linenum],
- A2.[ARBillLine] as [arbillLine],
- A2.[Maturity] as [maturity],
- A2.[AROCMoney_TotalMoney] as [totalmoney
示例代碼select
- A.[DocNo] as [docno],
- A1.[Item_ItemCode] as [itemcode],
- A2.[LineNum] as [linenum],
- A2.[ARBillLine] as [arbillLine],
- A2.[Maturity] as [maturity],
- A2.[AROCMoney_TotalMoney] as [totalmoney],
- A2.[AROCMoneyBalance_TotalMoney] as [totalBalanceMoney]
- into #tempShouhuoFenqi
- from AR_ARBillHead as A
- left join [AR_ARBillLine] as A1 on (A.[ID] = A1.[ARBillHead])
- left join [AR_ARInstalment] as A2 on (A1.[ID] = A2.[ARBillLine])
- group by A.DocNo,A1.Item_ItemCode,A2.LineNum,A2.ARBillLine,A2.Maturity,A2.AROCMoney_TotalMoney,A2.AROCMoneyBalance_TotalMoney
- -- select * from #tempShouhuoFenqi
- -- drop table #tempShouhuoFenqi
合同起始日期：第期的日期
- select docno,arbillline,maturity1
- into #tempMaturity1 from
- (
- select docno,arbillline
- ,maturity as maturity1,
- row_number() over
- (partition by docno,arbillline
按docno,arbillline分組
order by maturity asc) as rowno --按maturity排序
- from #tempShouhuoFenqi ) x
where x.rowno=2 --取SQL Server分組排序后的第行
- ---- select * from #tempMaturity1
- ---- drop table #tempMaturity1
以上的相關(guān)內(nèi)容就是對(duì)SQL Server分組排序后取每組的第N行數(shù)據(jù)的介紹，望你能有所收獲。
【編輯推薦】
- SQL Server數(shù)據(jù)庫(kù)管理中的10大紐帶
- 安裝MS SQL Server 2000失敗的緣由是什么？
- SQL Server索引實(shí)際結(jié)構(gòu)的理解
- SQL Server索引的使用誤區(qū)講述
- C#來(lái)對(duì)SQL Server存儲(chǔ)過(guò)程進(jìn)行創(chuàng)建
責(zé)任編輯：佚名
來(lái)源：
csdn.net
