Daniel Janik is currently running an Oracle versus SQL Server series, looking at how the two database systems expose common functionality. His latest topic is pagination:
Today’s topic is Pagination. Paging is a really important feature for web pages and applications. Without it you’d be passing large amounts of data to the application and expecting the application code to figure out which rows it needed to display.
Thankfully, someone smart came up with a way to do this on the database so you’re not returning gigs and gigs of data to the webserver to sort through.
Read on to see how the two platforms do this.