Suraj Mishra
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

--

--

Suraj Mishra
Suraj Mishra

Written by Suraj Mishra

Staff Software Engineer @PayPal ( All opinions are my own and not of my employer )

No responses yet