SQL Server Row_number (i)

Row_number Sub-page

SELECT
TOP 10* --pagesize =10
from
(
SELECT
*, Row_number () over (ORDER by a.bsqid ASC) as number
from
Tb_rt_bsqdata a
) as tablenumber
WHERE

Number > 0*10 --pageindex = 0, pageSize =10

--Sort all the data in the table by a number.
--then query for numbers greater than pageindex*pagesize
--for example, the first page of pageindex=0 indicates that the query number is greater than 0*10 data
--Red Part Two as can not be omitted, will error

SQL Server Row_number (i)