| USE wikidatawiki_p;
SELECT pid1, COUNT(DISTINCT qid1), SUM(count) FROM... |
7 years ago |
| USE wikidatawiki_p;
SELECT pid1, COUNT(DISTINCT qid1), SUM(count) FROM... |
7 years ago |
| USE wikidatawiki_p;
SELECT pid1, COUNT(DISTINCT qid), SUM(count) FROM... |
7 years ago |
| USE wikidatawiki_p;
SELECT pid1, COUNT(*), SUM(count) FROM wbs_propertypairs... |
7 years ago |
| USE wikidatawiki_p;
SELECT pid1, COUNT(*) FROM wbs_propertypairs GROUP BY 1; |
7 years ago |
| USE wikidatawiki_p;
SELECT COUNT(DISTINCT pid1) FROM wbs_propertypairs; |
7 years ago |
| USE wikidatawiki_p;
SELECT DISTINCT pid1, qid1 FROM wbs_propertypairs; |
7 years ago |
| USE wikidatawiki_p;
SELECT * FROM wbs_propertypairs LIMIT 2; |
7 years ago |
| USE wikidatawiki_p;
SHOW TABLES; |
7 years ago |
