janbenetka/group_concat.sql

Created October 28, 2020 21:49

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/janbenetka/3aff4af86a3e6f8f8dbbb858b734386f.js"></script>
Save janbenetka/3aff4af86a3e6f8f8dbbb858b734386f to your computer and use it in GitHub Desktop.

Download ZIP

[BigQuery: Concat all text of grouped by rows] #bigquery #groupby

Raw

group_concat.sql

	SELECT url, COUNT(*) AS popularity, GROUP_CONCAT(tweet)
	FROM Table GROUP BY url ORDER BY popularity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment