;WITH CTE AS
(
Select * From
(
SELECT ROW_NUMBER() OVER(ORDER BY StatusDate) AS SrNo, FirstName
From Tab1
UNION ALL
SELECT ROW_NUMBER() OVER(ORDER BY StatusDate) AS SrNo, FirstName
From Tab2
) v
)
Select * From CTE
是否有可以Row_Number()
在Tab1中生成后继续的操作。因此,如果第一个结果UNION
以10000结尾,则UNION中的第二个表应从10001开始
注意:我想要Row_Number()
它,因为它位于Select * From
因此,我不能将其更改为:
;WITH CTE AS
(
Select *, ROW_NUMBER() OVER(ORDER BY StatusDate) AS SrNo From
(
SELECT FirstName
From Tab1
UNION ALL
SELECT FirstName
From Tab2
) v
)
Select * From CTE
任何帮助是极大的赞赏。
由于您不对数据进行分区,因此最大row_number应该等于行数,因此您可以简单地将tab1中的行数添加到tab2中的行数:
;WITH CTE AS
(
SELECT * FROM
(
SELECT
ROW_NUMBER() OVER(ORDER BY StatusDate) AS SrNo,
FirstName
FROM Tab1
UNION ALL
SELECT
ROW_NUMBER() OVER(ORDER BY StatusDate) + (SELECT COUNT(*) FROM tab1) AS SrNo,
FirstName
FROM Tab2
) v
)
SELECT * FROM CTE
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句