Re: SELECT

From: Andreas Stephan <andreas.stephan.as_at_bayer-ag.de>
Date: Fri, 21 Sep 2001 11:40:40 +0200
Message-ID: <9of1uo$sbi5@byz672.bayer-ag.com>

select * from tablename where ROWNUM < 11;

Regards
Andy

Uli Herberg <ulrich.herberg_at_lrz.tu-muenchen.de> schrieb in im Newsbeitrag: 9oevqu$qvu$1_at_wsc10.lrz-muenchen.de...
> I am new to Oracle, I only have some exprerience in MySQL. In MySQL there
is
> a SELECT statement used to limit the number of rows:
> SELECT * FROM tablename LIMIT 0,10;
> (this would show the first ten entries)
>
> How can I do this in Oracle7 ?
>
> Thanks a lot
> Uli
>
>
Received on Fri Sep 21 2001 - 04:40:40 CDT