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 vote319 views1 answer
Django mysqlclient connection string
SQL
0 vote330 views1 answer
Kotlin sqlite delete row
SQL
0 vote342 views1 answer
Postgres type equivalent to timespan c#
SQL
0 vote324 views2 answers
Sql drop view if exists
SQL
0 vote342 views1 answer
Linebreak sql
SQL
0 vote339 views1 answer
Django mssql backend
SQL
0 vote343 views1 answer
Why we have to set the password for my sql server
SQL
0 vote368 views1 answer
Get statis values sql
SQL
0 vote391 views1 answer
Mysql delete entire row on condition
SQL
0 vote329 views1 answer
Exclude last comma separated string mysql
SQL