01 Feb 21 · Ryan-Dallas · #bigquery ·   Bookmark   ×

SQL query to get count of each group in Google BigQuery

Data

Metric
3
3
6
6

To get the count of each Group:

SELECT Metric, COUNT(Metric) `Count`
FROM `project.dataset.your_table`
GROUP BY Metric

Result:

Metric | Count
6      | 2
3      | 2

Ryan-Dallas

posted on 01 Feb 21

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds