Posts by Lucas BSM • 1 point

• 0

  votes

  0

  answers

  42

  views

  Q: Repeat lines in Array: is it possible with UNNEST? or is there any other way? - Bigquery

  I made this query in SQL in Bigquery (Google): SELECT FORMAT_DATE("%E4Y-%m", date) AS Mes, cliente, ARRAY_AGG( DISTINCT date ORDER BY date DESC LIMIT 2) AS date FROM…

  sql array bigquery

  asked 3 years, 4 months ago Lucas BSM 1