Hi Dimitris,

On 03-Jan-14 11:06 AM, Dimitris Kontokostas wrote:
Hi & happy new year to all!

I noticed that virtuoso doesn't support group by / having in ask queries
Is this a bug or not supported yet?

e.g.

ASK
WHERE
  { ?resource <prop> ?c }
GROUP BY ?resource
HAVING ( count(?c) > 1 )



Happy New Year to you too!

IMO you need to use inner SELECT statement i.e.:

ASK WHERE
{
SELECT ?resource  COUNT ( ?c ) AS ?total WHERE
  {
    ?resource <prop> ?c
  }
 GROUP BY ?resource
 HAVING COUNT ( ?c) > 1
}

example of live results (true): -- http://bit.ly/1lEr1Rw
example of SPARQL query:   -- http://bit.ly/1g5mqqm


Best Regards,
Rumi Kocis

Best,
Dimitris

--
Kontokostas Dimitris


------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT
organizations don't have a clear picture of how application performance
affects their revenue. With AppDynamics, you get 100% visibility into your
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk


_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature

------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT 
organizations don't have a clear picture of how application performance 
affects their revenue. With AppDynamics, you get 100% visibility into your 
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349831&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users

Reply via email to