Re: Select Top ... * from ... command

From: Ethel Aardvark <bigjobbies_at_hotmail.com>
Date: 9 Jul 2003 01:49:25 -0700
Message-ID: <1a8fec49.0307090049.3f4099c4_at_posting.google.com>


Either:

   select *
   from myTable
   where rownum <= 100

or

   rtfm

ETA jdragon <member32810_at_dbforums.com> wrote in message news:<3087807.1057697008_at_dbforums.com>...
> In SQL Server, I can execute this query -> select top 100 * from myTable
>
> How do I do this in Oracle?
Received on Wed Jul 09 2003 - 10:49:25 CEST

Original text of this message