Hi Savalia,
This script will show error message
Ambiguous column name 'EMPID'.
I have corrected your script
SELECT * FROM (
SELECT ROW_NUMBER() OVER(ORDER BY EmpID DESC) as RowNo,Emp.EMPID, EMP.FirstName
From Emp
UNION
SELECT ROW_NUMBER() OVER(ORDER BY Emp.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 20