Convert Teradata qualify row_number() to Google BigQuery

How can I translate this query into Big query?

select subsequent_month from dbc.tables \nqualify row_number() over (order by tablename) <= 24\n

There is no QUALIFY command in Bigquery.

Below is for BigQuery Standard SQL equivalent:

#standardSQL\nSELECT subsequent_month FROM (\n      SELECT subsequent_month, ROW_NUMBER() OVER (ORDER BY tablename) as RN\n      FROM dbc.tables \n) WHERE RN <= 24

Ryan-Dallas

posted on