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

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

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. Received on Mon Aug 07 2000 - 00:00:00 CDT