Many times I have been asked to create reports that only show a certain set of rows within a query to keep a webpage from getting too huge. It’s relatively easy to do by pulling the entire set of data and segmenting it in the application but that is not always practical with large data sets or limited application memory. I have finally been led to a possible solution in an Ask Tom Oracle article where he refers to a nested query to trim off the unused data.

Now, to try it…