Thanks Patrick, problem solved. On Thu, Jul 8, 2010 at 2:38 PM, Patrick van Kleef <[email protected]>wrote:
> Hi Nikolaos, > > > >> I am using Virtuoso 6.1 as a relational database backend (so far). I see >> in the select statement reference >> >> http://docs.openlinksw.com/virtuoso/SELECTSTMT.html >> >> that the LIMIT construct (found e.g. in mysql) is not supported. >> >> How would I submit an sql query of the form: >> >> SELECT t FROM some_table ORDER BY t DESC LIMIT 1 OFFSET 50 >> >> is there a workaround for the LIMIT and OFFSET constructs in Virtuoso? If >> no, are there any plans to support LIMIT? >> >> > You need to use the TOP function which is the SQL-92 compliant way of doing > this e.g.: > > http://docs.openlinksw.com/virtuoso/SELECTSTMT.html#topselectoption > > > SELECT TOP (50,1) t FROM some_table ORDER BY t DESC > > which will skip the first 50 records from some_table based on the ordering > and returns just 1 record. > > > > Patrick > >
