Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

SQL LIMIT and OFFSET

3 posts in General Discussion Last posting was on 2009-09-15 14:48:38.0Z
Stas Posted on 2009-09-15 13:59:33.0Z
Sender: 2ffd.4aae3e20.1804289383@sybase.com
From: Stas
Newsgroups: ianywhere.public.general
Subject: SQL LIMIT and OFFSET
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4aaf9dc5.5e61.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 15 Sep 2009 06:59:33 -0700
X-Trace: forums-1-dub 1253023173 10.22.241.41 (15 Sep 2009 06:59:33 -0700)
X-Original-Trace: 15 Sep 2009 06:59:33 -0700, 10.22.241.41
Lines: 2
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7717
Article PK: 6758

Does Sybase SQL support something like LIMIT and OFFSET to
read only a defined amount of rows?


Chis Keating (Sybase iAnywhere) Posted on 2009-09-15 14:15:47.0Z
From: "Chis Keating (Sybase iAnywhere)" <keating_nospam@sybase.com>
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: SQL LIMIT and OFFSET
References: <4aaf9dc5.5e61.1681692777@sybase.com>
In-Reply-To: <4aaf9dc5.5e61.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4aafa193@forums-1-dub>
Date: 15 Sep 2009 07:15:47 -0700
X-Trace: forums-1-dub 1253024147 10.22.241.152 (15 Sep 2009 07:15:47 -0700)
X-Original-Trace: 15 Sep 2009 07:15:47 -0700, vip152.sybase.com
Lines: 5
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7718
Article PK: 6760

SELECT TOP n START AT m

Stas wrote:
> Does Sybase SQL support something like LIMIT and OFFSET to
> read only a defined amount of rows?