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

0 vote197 views2 answers
Sql use not in
SQL
4 votes237 views2 answers
Postgresql float data type
SQL
0 vote241 views1 answer
Sql tablo hangi sp de
SQL
1 vote211 views1 answer
SQL Integer devision
SQL
0 vote240 views1 answer
Ceil upto 2 decimal place mysql
SQL
1 vote245 views1 answer
Check current sequence value postgres
SQL
0 vote215 views1 answer
Postgres grep entire database
SQL
0 vote201 views1 answer
T-sql email validation
SQL
0 vote211 views4 answers
User defined function sql
SQL
2 votes236 views1 answer
Dbms transaction (psql)
SQL