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

25 votes286 views1 answer
Mysql grant all privileges to a user
SQL
0 vote320 views1 answer
Select distinct after join
SQL
0 vote289 views1 answer
Check if string is a number sql
SQL
0 vote298 views1 answer
Oracle archivelog usage
SQL
0 vote279 views1 answer
Postgres select except
SQL
1 vote317 views3 answers
How to pass password to mysql command line
SQL
0 vote282 views1 answer
Mysql date time string format python
SQL
0 vote274 views1 answer
Backup a table in sql
SQL
0 vote240 views1 answer
Check if due date is less than todays date sql
SQL
22 votes277 views6 answers
Create sql table
SQL