Prev Up Next
1.5.59.What is the difference between the functions SAMPLE, GROUP_CONCAT and GROUP_DIGEST? Home 1.5.61.How Do I Clean Up Errant Data using SPARQL Update Language?

1.5.60.How Do I use CONSTRUCT with objects which are value of aggregate function?

The following section demonstrates usage example of CONSTRUCT Query with object which is a value of the aggregate function COUNT:

  1. Assume following SPARQL SELECT Query:

    SELECT DISTINCT ?category COUNT(?category) AS ?count
WHERE
  {
    ?s<http://purl.org/dc/terms/subject> ?category
    FILTER(?s =<http://dbpedia.org/resource/Higgs_boson> || ?s =<http://dbpedia.org/resource/Gluon>)
  }

  2. To present it as CONSTRUCT Query, one should put "SELECT DISTINCT" into the CONSTRUCT's WHERE clause as a subquery. So for example it could be:

    
CONSTRUCT
  {
    ?category a<http://www.w3.org/2004/02/skos/core#Concept> .
    ?category<http://www.turnguard.com/virtuoso/aggregates#count>  ?count
  }
WHERE
  {
    {
      SELECT DISTINCT ?category COUNT(?category) AS ?count
      WHERE
        {
          ?s <http://purl.org/dc/terms/subject> ?category
          FILTER(?s =<http://dbpedia.org/resource/Higgs_boson> || ?s =<http://dbpedia.org/resource/Gluon>)
        }
    }
  }
Prev Up Next
1.5.59.What is the difference between the functions SAMPLE, GROUP_CONCAT and GROUP_DIGEST? Home 1.5.61.How Do I Clean Up Errant Data using SPARQL Update Language?