Re: how can i select top 100 with a sql statement in oracle
From: DL <donlcs_at_yahoo.com>
Date: 19 Feb 2002 08:38:59 -0800
Message-ID: <604bb90c.0202190838.3147db3e_at_posting.google.com>
Date: 19 Feb 2002 08:38:59 -0800
Message-ID: <604bb90c.0202190838.3147db3e_at_posting.google.com>
Try
select column(s)
from tblOwner.tblName
where rownum < 101
DL
sohelcsc_at_yahoo.com (Leader) wrote in message news:<b1a93c73.0202182341.41a56f2d_at_posting.google.com>...
> Hi all,
> I need a sql statement which will select top 100 or whatever from table.
> please reply me asap
>
>
> thanks
> hoque
Received on Tue Feb 19 2002 - 17:38:59 CET