1 min readSep 6, 2020
Probably something like this would work ?
#standardSQL
SELECT
* EXCEPT(row_number)
FROM (
SELECT
*,
ROW_NUMBER()
OVER (ORDER BY updated_on) row_number
FROM
`TABLE_NAME`)
WHERE
row_number = 1
Probably something like this would work ?
#standardSQL
SELECT
* EXCEPT(row_number)
FROM (
SELECT
*,
ROW_NUMBER()
OVER (ORDER BY updated_on) row_number
FROM
`TABLE_NAME`)
WHERE
row_number = 1
Staff Software Engineer @PayPal ( All opinions are my own and not of my employer )