SQL LIMIT and OFFSET

#1

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

#2

Yes. SQL Anywhere uses the "TOP N START AT" construct to limit the set
of rows returned by a query. See:

http://dcx.sybase.com/index.php#http...ormatting.html

Nathan Auch
Sybase iAnywhere

Stas wrote:

Quote:

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

#3

OK. Thank you.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL LIMIT and OFFSET

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general

SQL LIMIT and OFFSET - 09-15-2009 , 09:01 AM

Re: SQL LIMIT and OFFSET - 09-15-2009 , 09:21 AM

Re: SQL LIMIT and OFFSET - 09-15-2009 , 09:47 AM