- From: Ricardo Almeida <ric_gabriel@hotmail.com>
 - Date: Fri, 16 Oct 2009 14:53:28 +0100
 - To: <public-sparql-dev@w3.org>
 
Received on Friday, 16 October 2009 17:21:12 UTC
I, 
i have a doubt in converting the followyng SQL,
SELECT p.nome, p.morada,
COUNT(r.matricula)
FROM Pessoa as p,
Registo as r 
WHERE p.nif = r.nif
GROUP BY p.nome
to SPARQL. 
PREFIX ex:<http://exemplo.com/ontologia Ex#>
SELECT ?nome ?morada COUNT(?matricula)
WHERE {?pId  rdf:type  <ex:Pessoa>
 ?rId rdf:type  <ex:Registo>
 ?pId <ex:nome> ?nome
 ?pId <ex:morada> ?morada
 ?rId <ex:temRegisto>
?registoId
 ?registoId <ex:matricula> ?matricula GROUP BY (?nome) }
Is  this correct, or the GROUP BY is an extension?
Thanks,
Ricardo.
 		 	   		  
_________________________________________________________________
Windows Live: Friends get your Flickr, Yelp, and Digg updates when they e-mail you.
http://www.microsoft.com/middleeast/windows/windowslive/see-it-in-action/social-network-basics.aspx?ocid=PID23461::T:WLMTAGL:ON:WL:en-xm:SI_SB_3:092010
Received on Friday, 16 October 2009 17:21:12 UTC