In MySql there is an option fetch only a page of results from a sql query. This is called LIMIT and OFFSET. This is perfect for something like posts in a guestbook.
|
1 |
SELECT * FROM 'posts' ORDER BY 'id' LIMIT 10 OFFSET 10 |
And this is how you do it in MSSQL
|
1 |
SELECT * FROM 'posts' ORDER BY 'id' OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY |