User
Difference between revisions of "Titodutta/প্রশ্ন"
< User:Titodutta
(→কত্ত ভাষা: ++) |
(++) |
||
| Line 12: | Line 12: | ||
GROUP BY ?language ?languageLabel ?code | GROUP BY ?language ?languageLabel ?code | ||
ORDER BY DESC(?nb) | ORDER BY DESC(?nb) | ||
| + | </query> | ||
| + | |||
| + | == আরেক == | ||
| + | <query yearmonth="Date" records="New records" speakers="New speakers" languages="New languages"> | ||
| + | SELECT | ||
| + | ?yearmonth | ||
| + | (COUNT(DISTINCT ?record) AS ?records) | ||
| + | (COUNT(DISTINCT ?speaker) AS ?speakers) | ||
| + | (COUNT(DISTINCT ?language) AS ?languages) | ||
| + | WHERE { | ||
| + | ?record prop:P2 entity:Q2 . | ||
| + | ?record prop:P6 ?date . | ||
| + | ?record prop:P5 ?speaker . | ||
| + | ?record prop:P4 ?language . | ||
| + | BIND( SUBSTR(str(?date), 0, 8) as ?yearmonth ) | ||
| + | } | ||
| + | GROUP BY ?yearmonth | ||
| + | ORDER BY ?yearmonth | ||
</query> | </query> | ||
Revision as of 04:00, 28 November 2020
Query মানে প্রশ্ন হবে কিনা, সে কথা যাক, এই পাতাটি আমার উপপাতা, এর নাম প্রশ্নই থাক