Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Limiting Returned Rows In Select Statement
I haven't tried this at all, but would
using a 'HAVING' clause do the trick?
On Fri, 27 Feb 1998 11:06:29 -0500,
"Randy Baker" <rsbakerZ_at_msn.com> wrote:
>Oops! The approach below doesn't work with ORDER BY because it cannot be
>included within the subquery.
>
>Any other thoughts on how one can accomplish the effect of adding WHERE
>ROWNUM < n except that the rows are limited *after* ordering occurs?
>
>Thanks,
Received on Mon Mar 02 1998 - 00:00:00 CST