Re: How to limit the number of rows returned in a select statement

On Tue, 03 Jun 1997 17:04:05 +0200, Stefan Fallet <stfallet_at_fallet.com> wrote:
<snip>
>I tryed using rownum. but this does not work with an order by.
<snip>

It's not a pretty solution but it works: use pl/sql and retrieve the first 15 rows.

Rownum works before the order by so you get the first 15 rows and then they are sorted.
HTH

--
John E. Leon Guerrero <jguerrer_at_infogration.com>
Oracle DBA Consultant