SQL Server Paging Query

1.not in method select top from books where ID not in (select top with ID from books) 2.row_number () function select * FROM (select *,ro W_number () over (order by ID) Numfrom books) a where num between and 40 3. Stored procedure paging create proc Proc_adminpages@pageindex i NT,--Current page @pagesize int--number per page asdeclare @begin int, @end int--define local variable set @[email protected]* (@pageIndex-1) +1--assignment set @[ Email protected]* @pageIndexselect * FROM (select Row_number () up (order by ID) as rowindex,* from Admin) Awhere RowIndex Between @begin and @end-executes exec proc_adminpages 2,1

SQL Server Paging Query