Re: How to do a limited select without using a where clause?

From: <cjaouich_at_my-deja.com>
Date: 2000/08/08
Message-ID: <8mp4of$pv$1@nnrp1.deja.com>#1/1

Thanks for the response, but I can only use the order by in the last component of the query (as per Ora doc)... Any other ideas? Thanks

-Cyril

---

Opérations téléphonie IP - Vidéotron Vidéotron - IP Telephony Operations

---

In article <F4155D9F9AA4D111B9990020AFBA52D53E0D50_at_class06.ip061.sfisoftware. com>,
  "Mark" <markag_at_wonderstats.com> wrote:
> Do something like this:
>
> SELECT * FROM
> (SELECT * FROM YOUR_TABLE
> WHERE MYCOL = MYCRITERIA
> ORDER BY MYORDER)
> WHERE ROWNUM <= 20;
>
> The inner select returns your data set, the outer select limits the
 number
> of rows.
>
> <cjaouich_at_my-deja.com> wrote in message news:8mmuo2
 $e5c$1_at_nnrp1.deja.com...
> > Hi, if I am not posting to the right forum, please point me in the
> > right direction.
> >
> > I am trying to do a SQL select that is using an order by clause. The
> > statement return 100+ rows, but I only want the first 5 rows of the
> > order by clause without specifying a limit or a where clause. Is
 this
> > possible?
> >
> > ie:
> >
> > select date, mac, fqdn, dhcp_ip from clients where mac like =
 '0000%'
> > order by date;
> >
> > this return me a list of 100+ rows, but I want only the last 5, and
 I
> > cannot use the date as a limit.
> >
> > Thanks in advance
> >
> > Cyril Jaouich
> > ------------------------------------
> > Opérations téléphonie IP - Vidéotron
> > Vidéotron - IP Telephony Operations
> > ------------------------------------
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Aug 08 2000 - 00:00:00 CDT