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: "Winkless, Geoff" <geoff.winkless AT pera.com>
  • To: 'TDS Development Group' <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Implementation of select Limit
  • Date: Fri, 9 Nov 2001 13:43:04 -0000


> 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

Geoff




Archive powered by MHonArc 2.6.24.

Top of Page