我有一张桌子 employeeSomething
tb_EmployeeSomething
EmpID| TypeID
1 | 1
1 | 1
1 | 1
1 | 2
1 | 2
2 | 2
2 | 2
2 | 2
现在我在程序中使用分页，返回值必须是
EmpID| TypeID| RowNum
1|1|1
1|2|2
2|2|3
这是我尝试过的
Declare @start int
Declare @end int
With Tmp2 as (
With Tmp1 as (
Select Distinct EmpID, TypeID
From tb_deductionBalance
)
Select *, row_number() OVER ( order by employeeID ) as RowNum
From Tmp1
)
Select * From Tmp2
Where RowNum Between @Start and @End
我不确定是否有更好的方法可以做到这一点。
对不起我的英语不好。
谢谢！
您不嵌套通用表表达式（CTE），而是用逗号分隔它们：
;With Tmp1 as (
Select Distinct EmpID, TypeID
From tb_deductionBalance
), Tmp2 as (
Select *,
row_number() OVER ( order by empID /* no employeeID in Tmp1 */) as RowNum
From Tmp1
)
Select * From Tmp2
Where RowNum Between @Start and @End
任何CTE都可以引用任何较早的CTE。
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句