FreeTDS Development Group

["Vitor Pinho" <vpp AT sageinfologia.com>]

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