Skip to content

Instantly share code, notes, and snippets.

@romain9292

romain9292/row_number_revenue.sql

Created August 15, 2022 14:51
Show Gist options
  • Save romain9292/98b6a97f3fd304ddaab974d983f96e4e to your computer and use it in GitHub Desktop.
Save romain9292/98b6a97f3fd304ddaab974d983f96e4e to your computer and use it in GitHub Desktop.
Download ZIP
[Numbering Functions - Row Number 2] Differences between numbering functions in BigQuery using SQL #SQL #BigQuery
Raw
row_number_revenue.sql
SELECT
*,
ROW_NUMBER() OVER(ORDER BY revenue DESC) AS row_number
FROM
`datastic.ranking.base_table`;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment