具有分页和计数的SQL Server查询

I want to make a database query with pagination. So, I used a common-table expression and a ranked function to achieve this. Look at the example below.I want to make a database query with pagination