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