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

Collapse
6: Re: How do I get first half rows from ORACLE table (response to 5)
Posted by Dirk Gomez on 11/19/03 11:34 AM
select * from
  (select a,b,c,rownum
  from foobar
  order by bla)
where rownum < 10

should do the trick.