SQL Paging Query

INSERT INTO info select ' admin36 ' from info; --FK Insertion Method
Select COUNT (*) from Info;

--not in implementing paged query
DECLARE @pageSize int Set @pageSize = number of 10;--rows
DECLARE @pageNo int Set @pageNo = 1000;--pages
Select Top * from Info
where ID not in (
Select Top (@pageSize * (@pageNo-1)) ID from Info
)

--Use the greater than sign > Implement paged Query
DECLARE @pageSize int Set @pageSize = 10; --Number of lines
DECLARE @pageNo int Set @pageNo = 1000; --pages
Select Top (@pageSize) * from Info where ID >
(select Max (ID) from--the maximum value of the first 10 data
(select Top (@pageSize * (@pageNo-1)) ID from Info) as Empinfo)--Query the first 10 data

--use row_num between for paging queries
SELECT * FROM
(select Row_number () over (order by ID) as no,* from Info) as EMP
where emp.no between and 110

SQL Paging Query