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 vote172 views1 answer
Uncomment listen_address=localhost
SQL
0 vote193 views1 answer
Sql query wordpress export post
SQL
4 votes177 views1 answer
Group by mysql and concatenate string
SQL
0 vote162 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL
0 vote169 views1 answer
Add plugins to mysql workbench
SQL
0 vote171 views1 answer
Enable Rabbitmq management plugin
SQL
1 vote172 views1 answer
Oracle avg
SQL
-1 vote181 views1 answer
Sql select data from one database and insert into a different database
SQL
0 vote169 views1 answer
Import all databases mysql
SQL
0 vote204 views1 answer
Mysql error codeigniter
SQL