Page wise record in SQL Server 10 records per page

 Get Page wise record in SQL Server 10 records each page

;with pagewise as

(

SELECT        ROW_NUMBER() OVER(ORDER BY id) AS rowno, ID, roww, name, city

FROM            Student ) select * from pagewise where rowno>9 and rowno<21 order by rowno

 

Next Topic