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. ********************************************************************************
