Originally posted by Raminder
A crude method is to use the ROWNUM pseudocolumn. Eg Select * from your_table where rownum between 25 and 50;
I don't see how this would be defined as 'crude', as this is the proper way to do 'windowing', which is very similar to this request.

However, I must ask - why in the world do you want to do this at all? It is a very odd request.

- Chris