W3C home > Mailing lists > Public > public-rdf-dawg@w3.org > October to December 2009

Re: More on the evil examples... and "What really happened to Limit per Resource?"

From: Axel Polleres <axel.polleres@deri.org>
Date: Mon, 9 Nov 2009 16:25:55 +0000
Cc: "SPARQL Working Group" <public-rdf-dawg@w3.org>
Message-Id: <765CCC98-CA03-45BA-9B9D-02649345EE60@deri.org>
To: "Olivier Corby" <Olivier.Corby@sophia.inria.fr>
Indeed, looks nice just using distinct instead of  of an aggregate.

Axel

On 9 Nov 2009, at 16:23, Olivier Corby wrote:

> In order to get one price per book, I suggest this  :
>
> PREFIX  : <http://books.example/>
>   SELECT SUM(?lprice) AS ?totalPrice
>   WHERE {
>     {select distinct ?org ?book where {
>       ?org :affiliates ?auth .
>       ?auth :writesBook ?book .}
>     }
>     ?book :price ?lprice
>   }
>   GROUP BY ?org
>   HAVING (SUM(?lprice) > 10)
>
>
>
> Olivier
>
Received on Monday, 9 November 2009 16:26:33 GMT

This archive was generated by hypermail 2.3.1 : Tuesday, 26 March 2013 16:15:40 GMT