Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: select statement
Vitek wrote:
>
> select ...
> where rownum<=10
>
> "Frank Chien" <chien2_at_ms5.hinet.net> wrote in message
> news:866f73$82jd2$1_at_news.ethome.net.tw...
> > how can I select 10 rows each time?
> >
That would probably not work right if the select were made from a view that is actually a join. Received on Thu Jan 20 2000 - 07:55:31 CST