freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: Implementation of select Limit

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

Implementation of select Limit, Vitor Pinho, 11/09/2001
- <Possible follow-up(s)>
- Re: Implementation of select Limit, Brian Bruns, 11/09/2001
- Re: Implementation of select Limit, Jez Humble, 11/09/2001
- Re: Implementation of select Limit, Vitor Pinho, 11/09/2001
- Re: Implementation of select Limit, Winkless, Geoff, 11/09/2001
- Re: Implementation of select Limit, Vitor Pinho, 11/09/2001
- Re: Implementation of select Limit, Steve Langasek, 11/09/2001
- Re: Implementation of select Limit, Michael Peppler, 11/09/2001
- Re: Implementation of select Limit, Michael Peppler, 11/09/2001
- Re: Implementation of select Limit, Brian Bruns, 11/09/2001
- Re: Implementation of select Limit, Rui Ribeiro, 11/10/2001
- Re: Implementation of select Limit, Eric Deutsch, 11/13/2001