Yes the behavior is different I believe it is partially implemented in Virtuoso but doesn't use the SAMPLE keyword currently, I think you have to use the special term sql:sample currently
Rob Vesse -- YarcData.com<http://YarcData.com> -- A Division of Cray Inc Software Engineer, Bay Area m: 925.960.3941 | o: 925.264.4729 | @: [email protected]<mailto:[email protected]> | Skype: rvesse 6210 Stoneridge Mall Rd | Suite 120 | Pleasanton CA, 94588 [cid:[email protected]] On Mar 22, 2012, at 12:28 PM, Diogo FC Patrao wrote: Hello Robert If your query contains a GROUP BY then you can only project grouped by variables (or apply an aggregate over a non-grouped variable) I see. It's different from RDBs that treat grouped expressions as columns and hence could be used as such. To get the behaviour you want you can use the SAMPLE aggregate which picks one value for that variable from all the solutions in the group e.g. ARQ 2.8.8 parsed it, however Virtuoso doesn't implement SAMPLE(). But thanks a million, now I sed that it is not a bug. dfcp
