Hi Amir, In SQL Virtuoso supports the “TOP” construct similar to SQL Server for limiting result sets of select queries. LIMIT and OFFSET are supported in Virtuoso SPARQL which is a defacto standard support by all SPARQL engines, and may be where the confusion comes from.
$ isql 1111 dba dba Connected to OpenLink Virtuoso Driver: 06.03.3131 OpenLink Virtuoso ODBC Driver OpenLink Interactive SQL (Virtuoso), version 0.9849b. Type HELP; for help and EXIT; to exit. SQL> select top 5 u_name from sys_users; U_NAME VARCHAR NOT NULL _______________________________________________________________________________ ATOM BLOG_API CURI Compound1 Compound2 5 Rows. -- 26 msec. SQL> Best Regards Hugh Williams Professional Services OpenLink Software Web: http://www.openlinksw.com Support: http://support.openlinksw.com Forums: http://boards.openlinksw.com/support Twitter: http://twitter.com/OpenLink On 20 Oct 2011, at 09:42, <[email protected]> wrote: > Hi all, > > When i run the sql query SELECT and i try to limit the number of returned > rows eg: “SELECT columns FROM table LIMIT num_rows”, > I always get “syntax error at 'num_rows' before ';'” > > Is the LIMIT modifier supported in sql mode? > > This webpage > http://en.wikibooks.org/wiki/SQL_Dialects_Reference/Select_queries/Limiting_results_of_select_query > indicates clearly that we can LIMIT the number of returned rows in Virtuoso. > So, please is there any specific configuration setup that should be done in > order to enable this feature? > > Many thanks, > Amir > > ******************************************************************************** > IMPORTANT.Les informations contenues dans ce message electronique y compris > les fichiers attaches sont strictement confidentielles > et peuvent etre protegees par la loi. > Ce message electronique est destine exclusivement au(x) destinataire(s) > mentionne(s) ci-dessus. > Si vous avez recu ce message par erreur ou s il ne vous est pas destine, > veuillez immediatement le signaler a l expediteur et effacer ce message > et tous les fichiers eventuellement attaches. > Toute lecture, exploitation ou transmission des informations contenues dans > ce message est interdite. > Tout message electronique est susceptible d alteration. > A ce titre, le Groupe France Telecom decline toute responsabilite notamment s > il a ete altere, deforme ou falsifie. > De meme, il appartient au destinataire de s assurer de l absence de tout > virus. > > IMPORTANT.This e-mail message and any attachments are strictly confidential > and may be protected by law. This message is > intended only for the named recipient(s) above. > If you have received this message in error, or are not the named > recipient(s), please immediately notify the sender and delete this e-mail > message. > Any unauthorized view, usage or disclosure ofthis message is prohibited. > Since e-mail messages may not be reliable, France Telecom Group shall not be > liable for any message if modified, changed or falsified. > Additionally the recipient should ensure they are actually virus free. > ******************************************************************************** > ------------------------------------------------------------------------------ > The demand for IT networking professionals continues to grow, and the > demand for specialized networking skills is growing even more rapidly. > Take a complimentary Learning@Ciosco Self-Assessment and learn > about Cisco certifications, training, and career opportunities. > http://p.sf.net/sfu/cisco-dev2dev_______________________________________________ > Virtuoso-devel mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/virtuoso-devel
