In MySQL, I can do the following query:
select first_name from `table` group by age
However, if I do something similar in BigQuery, I get the following error:
SELECT list expression references column first_name which is neither grouped nor aggregated
How would we write the equivalent mysql aggregation query in BigQuery?
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…