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 vote253 views1 answer
Call object contructor and call methods of object
SQL
1 vote192 views1 answer
Strict in postgres SQL
SQL
0 vote236 views1 answer
Turn on foreign keys check mysql
SQL
0 vote256 views1 answer
Mysqli_connect using prepare statement
SQL
0 vote301 views1 answer
Oracle convert int to date
SQL
0 vote220 views1 answer
Stuff in sql server
SQL
1 vote261 views1 answer
Update from table tsql
SQL
0 vote260 views1 answer
Consecutive numbers sql
SQL
-3 votes252 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL
3 votes243 views2 answers
Mysql create database
SQL