ROW_NUMBER() OVER PARTITON BY Syntax in Bigquery

404

posted on

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds

Post Comment

Did "where rownum=1;" work?

I tried it and it did not recognize the rownum as a colum

Good catch! you will need a derived table for it to work

Fixed the article to reflect the correct syntax