Finn Årup Nielsen
Finn Årup Nielsen

Reputation: 6726

LIMIT with GROUP in SPARQL

Say, that I, with the Wikidata Query Service, would like to sample 10 lexemes for each language. Would that be possible in SPARQL?

This would just give me 10 lexemes in any language:

SELECT ?lexeme ?language
WHERE { ?lexeme dct:language ?language . }
LIMIT 10

This would give me one lexeme for each language:

SELECT (SAMPLE(?lexeme) AS ?example_lexeme) ?language
WHERE { ?lexeme dct:language ?language . }
GROUP BY ?language
LIMIT 10

It would be something like (abusing SPARQL):

SELECT ?lexeme ?language
WHERE { ?lexeme dct:language ?language . }
LIMIT 10 PER ?language

I now see there is a related question: Select top X results per group

Upvotes: 4

Views: 41

Answers (0)

Related Questions