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

15 votes349 views4 answers
Pl sql
SQL
0 vote332 views1 answer
Java mysql date format
SQL
1 vote335 views2 answers
How to drop a unique constraint in sql
SQL
1 vote371 views1 answer
Insert value to new table by joining 2 different tables
SQL
1 vote366 views1 answer
SQL query to get all table records count from a database
SQL
0 vote365 views1 answer
SQL division of an integer by another integer get float CAST
SQL
14 votes345 views3 answers
SQL trim
SQL
2 votes343 views2 answers
Mysql get time from datetime
SQL
3 votes373 views1 answer
Create a table with an id in mysql
SQL
0 vote371 views1 answer
Faire une recherche par liste de mot clé sql
SQL