GROUP_CONCAT is aggregate function that performs a string concatenation across the values of an expression with a group. The order of the strings is not specified. The separator character used in the concatenation may be given with the scalar argument delimiter.
Note: the "sql:" prefix is mandatory when this aggregate is used in SPARQL queries. In SQL queries the prefix is "DB.DBA".
any
SQL>SPARQL
SELECT ?name, (sql:GROUP_CONCAT(?near, ' , '))
WHERE
{
GRAPH ?g
{
[] a foaf:Person ;
foaf:name ?name ;
foaf:based_near ?near
}
}
LIMIT 10
name callret-1
ANY ANY
________________________________________________
Jonas Smedegaard nodeID://b6190457 , nodeID://b6190507
Dimitar Dimitrov http://mitko.dnsalias.net:8005/dataspace/person/dav#based_near , http://ods-qa.openlinksw.com/dataspace/person/dav1#based_near , http://ods-qa.openlinksw.com/dataspace/person/dav2#based_near
Adam Harvey nodeID://b780751
John Breslin nodeID://b56694
John Breslin nodeID://b56694
Chris Bizer http://sws.geonames.org/2950159/ , http://dbpedia.org/resource/Berlin
Leo Sauermann nodeID://b53598
Andreas Harth http://dbpedia.org/resource/Karlsruhe , nodeID://b53559 , nodeID://b53569
Alexandre Passant http://dbpedia.org/resource/Galway
Leon Lord http://ods-qa.openlinksw.com/dataspace/person/t1#based_near
No. of rows in result: 10
