Re: [MonetDB-users] MonetDB LIMIT usage

On 05-01-2011 09:09:58 -0500, Brett Spurrier wrote:

Hi all,

I am trying to use the LIMIT clause in my query, and while this should be fairly straight froward, I am having trouble learning the differences between Monet's LIMIT and other T-sql LIMITS.

I have the simple query: SELECT * FROM signatures ORDER BY scale ASC LIMIT 1;

which works great and as expected. However, I really want the second record, so in other databases I can use: SELECT * FROM signatures ORDER BY scale ASC LIMIT 1, 1;

I have also tried: SELECT * FROM signatures ORDER BY scale ASC LIMIT 1 1;

try this: SELECT * FROM signatures ORDER BY scale ASC OFFSET 1 LIMIT 1;