Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: What do Oracle professionals think of Fabian Pascal?
> ROWNUM is a hack that predated analytical SQL extensions, and some of
> these extensions do make sence for an end user. Otherwise, how do you
> express the query
Without using ROWNUM please provide the equivalent to the following:
SELECT *
FROM t
WHERE rownum < 37;
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Tue Oct 04 2005 - 12:32:26 CDT