GROUP BY in search results?
Posted: 12 Aug 2025 18:15
Is it possible to do something similar to the "GROUP BY" in SQL (or "table()" in R) when searching CPDL?
In particular, I am trying to list and count the languages used for specific texts, e.g.
In particular, I am trying to list and count the languages used for specific texts, e.g.
Code: Select all
SELECT language, COUNT(*) FROM all_pieces WHERE "LinkText" = 'Magnificat' GROUP BY language ORDER BY COUNT(*) DESC