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

5 votes191 views3 answers
Sql make column nullable
SQL
0 vote234 views1 answer
Sql convert float to string
SQL
0 vote201 views1 answer
Shell script to log mysql cpu usage
SQL
5 votes240 views3 answers
Sql server utc to local
SQL
2 votes278 views1 answer
Brew start postgres manual
SQL
0 vote205 views1 answer
Sql sum show 0 result
SQL
0 vote219 views1 answer
How to add unique key constraint in mysql
SQL
3 votes166 views1 answer
Oracle failed login attempts
SQL
0 vote224 views1 answer
How to add mysql to path on termin after installation
SQL
0 vote190 views1 answer
Ignore case in string sql
SQL