Is there a way to get count information like in SQL ?

techfort / LokiJS

javascript embeddable / in-memory database

http:/techfort.github.io/LokiJS

MIT License

6.73k stars 482 forks source link

Is there a way to get count information like in SQL ? #860

Closed dlanorf closed 3 years ago

dlanorf commented 4 years ago

For example, I can use below sql to get the number of states in each country with "COUNT" and "GROUP BY". How can I achieve the same with LokiJS ?

SELECT country, state, COUNT(state) AS state_number FROM people GROUP BY country, state

stale[bot] commented 3 years ago

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.