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: "Vitor Pinho" <vpp AT sageinfologia.com>
  • To: "'TDS Development Group'" <freetds AT franklin.oit.unc.edu>
  • Cc: <geoff.winkless AT pera.com>
  • Subject: Re: Implementation of select Limit
  • Date: Fri, 9 Nov 2001 14:30:26 -0000



I already tried this, but I can't change all my SQL instructions and
I want to use just one function that process the same SQL instruction in
MySql and SqlServer in order
to return the resultset.

Thanks anyway,
Vpp


-----Original Message-----
From: bounce-freetds-138221 AT franklin.oit.unc.edu
[mailto:bounce-freetds-138221 AT franklin.oit.unc.edu]On Behalf Of
Winkless, Geoff
Sent: sexta-feira, 9 de Novembro de 2001 13:43
To: TDS Development Group
Subject: [freetds] Re: Implementation of select Limit


> 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

---
You are currently subscribed to freetds as: [vpp AT sageinfologia.com]
To unsubscribe, forward this message to
$subst('Email.Unsub')





Archive powered by MHonArc 2.6.24.

Top of Page