sql生成排序列

注意红色标示 dense，缺少则可能导致不连续

 

SELECT DISTINCT dbo.ksxx.sfzh, dbo.ksxx.xm, dbo.Receiptxx.ReceiptStyle, dbo.Receiptxx.CzyPid, dbo.Receiptxx.CzTime, dense_rank() OVER (partition BY CzyPid

ORDER BY CzTime) AS CzNum, dbo.Orgxx.Orgname, dbo.Orgxx.ReceiptorName, dbo.Orgxx.ReceiptorTel
FROM  dbo.ksxx INNER JOIN
               dbo.Receiptxx ON dbo.ksxx.sfzh = dbo.Receiptxx.sfzh LEFT OUTER JOIN
               dbo.Orgxx ON dbo.Receiptxx.CzyPid = dbo.Orgxx.ID