Bigquery select distinct values

SELECT cc_info
FROM user
WHERE date = ?
GROUP BY cc_info

Simply use group by,

SELECT cc_info
FROM user
WHERE date = ?
GROUP BY cc_info

If you want to COUNT over DISTINCT values you can use,

SELECT COUNT(DISTINCT cc_info)
FROM user
WHERE date = ?

Try using group by

SELECT cc_info
FROM user
WHERE date = ?
group by cc_info

Related