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;
However, these both fail in MonetDB. According to: http://monetdb.cwi.nl/SQL/Documentation/Queries.html#Queries
it looks like it should be supported. Does anyone have any insight as to how to grab the second record in MonetDB (I.e., limiting the record results to one with an offset of one)???
I am at a loss here.
Cheers, Brett