Using limit for individuals not statements

Question

I'm trying to query a FOAF like dataset. I want to query the dataset for 10 people (and only people with friends) and get back their names and their friends uris.

Based on this solution: http://answers.semanticweb.com/questions/21072/limiting-individuals-not-statements I tried the foloowing:

select ?person ?name ?knows
where {
    ?person a foaf:person .
    ?person foaf:name ?name .
    ?person foaf:knows ?knows .
    { 
       select ?person where {
          ?person a foaf:person
      } LIMIT 10
   }
}

This query still limits by statements and not the resource, so if the first person returned from this query has 10 friends, I'm only going to get the statements for that first person.

What am I doing wrong?

Answer 1

Well that query should work as stated, one possible issue is that it is entirely possible that the inner query is returning the same ?person 10 times because of how your data is organised. Try adding the DISTINCT modifier to your inner query and see if that makes a difference:

SELECT ?person ?name ?knows
WHERE {
    ?person a foaf:person .
    ?person foaf:name ?name .
    ?person foaf:knows ?knows .
    { 
       SELECT DISTINCT ?person WHERE {
          ?person a foaf:person
      } LIMIT 10
   }
}

If this still doesn't give you the result you want this may be a bug in the SPARQL engine you are using, what are you using to make your query and how is your data stored?

Using limit for individuals not statements

Follow this question

Upcoming Events

Related questions