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: <jez AT whatsonwhen.com>
  • Subject: Re: Implementation of select Limit
  • Date: Fri, 9 Nov 2001 12:56:09 -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:

Table1

c1|c2
1|1
2|2
3|3
4|4
5|5
6|6

select * from table1 limit 2,2
3|3
4|4

The ideia is to use this in webpages where you have a large number of
records in your result set and don't want to get all of them to the script
all the time, only the ones that interesst.

Best regards,
vpp


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


>Doesn't SQL Server have a limit-type statement? Sybase doesn't but I'm
>pretty sure MS added one....back, back, back into the recesses of my mind,
>I think its like:

>select top 100 * from table

Absolutely correct.

---
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