579
edits
Project:SPARQL/examples: Difference between revisions
→Counting Dates
| Line 1,536: | Line 1,536: | ||
<sparql tryit="1"> | <sparql tryit="1"> | ||
# count distinct dates for women (who have at least one) | # count distinct dates for women (who have at least one) | ||
# uncomment HAVING line for women with only one | |||
# CAVEAT: there may be some discrepancies between dates shown on wiki pages and dates returned by sparql | # CAVEAT: there may be some discrepancies between dates shown on wiki pages and dates returned by sparql | ||
PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | PREFIX bnwd: <https://beyond-notability.wikibase.cloud/entity/> | ||
| Line 1,573: | Line 1,574: | ||
} # /where | } # /where | ||
GROUP BY ?person ?personLabel | GROUP BY ?person ?personLabel | ||
# HAVING(?count=1) | |||
ORDER BY ?count ?person | ORDER BY ?count ?person | ||
</sparql> | </sparql> | ||