Skip to main content

how to use Pagenation in MSSQL

SELECT * from  {table}
    ORDER BY "{column}"
    OFFSET page number start from zero} ROWS
    FETCH NEXT {PAge Size} ROWS ONLY

Tags