如何在ROW_NUMBER（）函数和Union中获取过滤器记录？

I have one Union Query for getting result from table. When only first query execute that time this working fine but if in second(union part) also return result that time it will not work. My query likeSelect * from (Select ROW_NUMBER() OVER(ORDER BY EmpID DESC) as RowNo, Emp.EMPID, EMP.FirstName From EmpUnionSelect ROW_NUMBER() OVER(ORDER BY EMPID DESC) as RowNo, Emp.EMPID, EMP.FirstName From Emp Inner Join EMPDetail On Emp.EmpID = EMPDetail.EMPID Where EMPDetail.IsActive=True ) as _EmpTable where RowNo between 1 and 20Please help me for this. I want to add paging using Row number. is there any other solution for this? 解决方案 这篇关于如何在ROW_NUMBER（）函数和Union中获取过滤器记录？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！