Skip to Content.
Sympa Menu

freetds - Re: Implementation of select Limit

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Michael Peppler <mpeppler AT peppler.org>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Implementation of select Limit
  • Date: Fri, 9 Nov 2001 08:38:05 -0800


Winkless, Geoff writes:
> > Maybe I didn't make myself clear. I don't want the top n records.
> >
> > I need the n top with an offset. For example:
>
> You could try
>
> SELECT IDENTITY(INT, 1, 1) id, *
> INTO #temp
> FROM blah
>
> SELECT * FROM #temp WHERE id BETWEEN 10 AND 20

Indeed. That is the generic way to achieve this functionality, and
should be at least as fast as the cursor example that the original
poster used in his example.

Michael
--
Michael Peppler - Data Migrations Inc. - http://www.mbay.net/~mpeppler
mpeppler AT peppler.org - mpeppler AT mbay.net
International Sybase User Group - http://www.isug.com




Archive powered by MHonArc 2.6.24.

Top of Page