Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Using ROWNUM with ORDER BY clause with a CASE statement
Brett Cramer wrote:
<snip>
> Is there a way to simply say "Give me the first 20 records of the
> resultset" without using ROWNUM??
would analytic functions be of any use here? (I don't do any complicated pagination, so I have no idea). Check the docs and and asktom.oracle.com for more, if so. Received on Thu Nov 06 2003 - 10:30:17 CST