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 votes232 views3 answers
Find duplicate keys in mysql
SQL
5 votes229 views2 answers
Oracle timestamp to date
SQL
0 vote226 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
39 votes240 views5 answers
Sql drop column
SQL
0 vote241 views1 answer
ORA-00942
SQL
0 vote230 views1 answer
ORACLE PARSE STRING
SQL
0 vote225 views1 answer
Vbscript clean up ADODB.Recordset
SQL
0 vote229 views1 answer
Delete record by id sql
SQL
2 votes213 views1 answer
Oracle create directory
SQL
0 vote236 views2 answers
Mysql unique two columns
SQL