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 <Fabian.Groffen@cwi.nl> wrote:
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