Re: Best method to SELECT TOP n TO m of a table
From: Will Clark <reply_only_to_newsgroup_please_at_noone-lives-here.com>
Date: Wed, 5 Nov 2003 12:10:24 +0000 (UTC)
Message-ID: <boapbg$2u3$1_at_titan.btinternet.com>
Date: Wed, 5 Nov 2003 12:10:24 +0000 (UTC)
Message-ID: <boapbg$2u3$1_at_titan.btinternet.com>
That's great, thanks :o)
"Troels Arvin" <troels_at_arvin.dk> wrote in message
news:pan.2003.11.04.19.24.04.92089_at_arvin.dk...
> On Tue, 04 Nov 2003 14:15:04 +0000, Will Clark wrote:
>
> > I was wondering if there was a better way to do a SELECT where it
returns
> > not the TOP 5 (or whatever) but, say, the TOP 6 to 8?
>
> I have written about the subject here:
> http://troels.arvin.dk/db/rdbms/#select-limit-offset
>
> --
> Greetings from Troels Arvin, Copenhagen, Denmark
>
Received on Wed Nov 05 2003 - 13:10:24 CET