LineID重组解决办法
LineID重组DECLARE @T TABLE(OrderNO INT,LineID INT)INSERT INTO @tSELECT 5,1 UNION ALLSELECT 5,2 UNIO
LineID重组
DECLARE @T TABLE(OrderNO INT,LineID INT)
INSERT INTO @t
SELECT 5,1 UNION ALL
SELECT 5,2 UNION ALL
SELECT 6,1 UNION ALL
SELECT 6,2 UNION ALL
SELECT 6,3 UNION ALL
SELECT 7,1 UNION ALL
SELECT 8,1 UNION ALL
SELECT 8,2
SELECT * FROM @T
问题是我想把OrderNO重组下,按流水号
如：
OrderNO,LineID
1,1
1,2
2,1
2,2
2,3
3,1
4,1
4,2
有没有ROW_NUMBER()这样的函数呢，但是这个是多条哦。谢谢
[解决办法]SELECT dense_RANK() over(order by orderno) as orderno, lineid FROM @T
