Thanks Fabian! I'll give that a try. I knew it had to be something simple I
was doing wrong.
Many thanks!
Brett
On Wed, Jan 5, 2011 at 6:21 AM, Fabian Groffen
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;
------------------------------------------------------------------------------ Learn how Oracle Real Application Clusters (RAC) One Node allows customers to consolidate database storage, standardize their database environment, and, should the need arise, upgrade to a full multi-node Oracle RAC database without downtime or disruption http://p.sf.net/sfu/oracle-sfdevnl _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users