Name

DB.DBA.GROUP_CONCAT_DISTINCT — returns a string that is concatenation of token strings delimited with delimiter

Synopsis

DB.DBA.GROUP_CONCAT_DISTINCT ( in token varchar ,
  in delim varchar );
 

Description

DB.DBA.GROUP_CONCAT_DISTINCT 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".

Parameters

token

An item that should be added to a delimited list.

delim

The delimeter character to be used in the concatenation.

Return Types

any

Examples

Example 24.288. Simple Use

SQL>SPARQL
SELECT ?name, (sql:GROUP_CONCAT_DISTINCT(?near, ' , '))
WHERE
  {
    GRAPH ?g
      {
        [] a foaf:Person ;
        foaf:name ?name ;
        foaf:based_near ?near
      }
  }
LIMIT 2

name callret-1
ANY  ANY
________________________________________________
Donny Hathaway   http://linkeddata.uriburner.com/about/id/entity/http/sws.geonames.org/3996063/ , http://linkeddata.uriburner.com/about/id/entity/http/sws.geonames.org/4990729/ , ..
Jill Scott           http://linkeddata.uriburner.com/about/id/entity/http/sws.geonames.org/3996034/ , http://linkeddata.uriburner.com/about/id/entity/http/sws.geonames.org/4990735/ , ...
No. of rows in result: 2