Forum OpenACS Development: Re: How do I get first half rows from ORACLE table

Collapse
Posted by Nis Jørgensen on
So, is there any way to return a subset of the records, based on an explicit ordering? Something like mySQL's LIMIT. It seems like ROWNUM can not be used for this purpose (although I may be wrong).
Collapse
Posted by Dirk Gomez on
select * from
  (select a,b,c,rownum
  from foobar
  order by bla)
where rownum < 10

should do the trick.