Re: LIMIT in a subselect, but without using subselects

Learn to use a CURSOR when limitting items fetched from the DB. Does
your application language support FETCHing rows? That's the place to
deal with limits, rather than using a crutch like LIMIT or ROWNUM. You
do use a different language for displaying the data don't you? Limits
like this is a display function, not a database function.

.