Bigquery select distinct values

google-bigquery

zdc · Jun 3, 2015 · Viewed 43.4k times · Source

How to select distinct values in Google Bigquery?

Query:

SELECT DISTINCT cc_info
FROM user
WHERE date = ?

Thanks!

Answer

SELECT cc_info
FROM user
WHERE date = ?
GROUP BY cc_info