Pagination sql

Pagination In Sql

--CREATING A PAGING WITH OFFSET and FETCH clauses IN "SQL SERVER 2012"
DECLARE @PageNumber AS INT, @RowspPage AS INT
SET @PageNumber = 2
SET @RowspPage = 10 
SELECT ID_EXAMPLE, NM_EXAMPLE, DT_CREATE
FROM TB_EXAMPLE
ORDER BY ID_EXAMPLE
OFFSET ((@PageNumber - 1) * @RowspPage) ROWS
FETCH NEXT @RowspPage ROWS ONLY;

Source: stackoverflow.com

Similar codes

7 votes172 views2 answers
How to create index mysql
SQL
0 vote174 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
0 vote156 views1 answer
We are intrested to work with your organization
SQL
23 votes150 views6 answers
Delete all rows from table sql
SQL
7 votes160 views2 answers
Oracle sql drop index
SQL
1 vote152 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
0 vote166 views1 answer
How to check common records in 2 table
SQL
1 vote163 views2 answers
Mysql between
SQL
0 vote156 views1 answer
Change role postgres
SQL
0 vote176 views1 answer
Sql_inner_join
SQL