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 vote348 views3 answers
Constraint sql
SQL
1 vote294 views1 answer
How to drop function in sql
SQL
1 vote288 views1 answer
How to select random rows from table
SQL
0 vote307 views1 answer
Sql find all different values in column
SQL
1 vote301 views2 answers
How to add amount between date in sql
SQL
0 vote298 views1 answer
Mysql dump everythign
SQL
0 vote288 views1 answer
1 column values in to 1 single row in sql
SQL
-1 vote292 views1 answer
Ssms connect with connection string
SQL
0 vote305 views1 answer
How to combine first and last nae into one columb sql
SQL
1 vote297 views1 answer
Select if then postgresql
SQL