I have a bigquery table with the following record
_id | hours | dateUpdated
id1 | 1 |2024-05-14 16:00:57 UTC
id1 | 2 |2024-05-15 16:00:57 UTC
id2 | 5 |2024-05-15 16:00:57 UTC
I would like to return the last updated record .The record from 2024-05-14 should be excluded because we have newer update
id1 | 2 |2024-05-15 16:00:57 UTC
id2 | 5 |2024-05-15 16:00:57 UTC
How can do this in BigQuery SQL.
Thanks for your help