----- Original Message -----
From: "Charlie Griefer" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, October 01, 2004 5:40 AM
Subject: Re: last 5 entries of query
> SELECT TOP 5 ... [columns]
> FROM [table]
> ORDER BY id DESC
>
>
> On Fri, 1 Oct 2004 05:36:50 +1200, Mark Henderson <[EMAIL PROTECTED]>
wrote:
> > I'm just wondering if there is an easier way to display only the the
last 5
> > entries of a query without having to use, in my case, max(id) and then
> > subtracting 5. This means I have to do a couple of queries to get the
> > resulting output and I thought it might be possible to do everything
inside
> > the one query.
> >
> > TIA
> > MarkH
> >
> >
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
