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 vote332 views1 answer
Mysql case when null
SQL
12 votes315 views2 answers
Delete all data in neo4j
SQL
1 vote312 views2 answers
How to drop a unique constraint in sql
SQL
0 vote339 views1 answer
Postgres populate table from another table
SQL
2 votes378 views1 answer
Oracle find constraints referencing a table
SQL
0 vote340 views1 answer
Mysql calculated column
SQL
0 vote329 views1 answer
Alter owner in PostgreSQL
SQL
0 vote343 views1 answer
Alter check command
SQL
1 vote335 views1 answer
Mysql event last execution
SQL
0 vote379 views1 answer
Mysql, how to query the table comments?
SQL