Hacker

SQL Window Functions: A Quick Review With Examples

Hello there! đŸ‘‹ I'm Luca, a BI Developer with a passion for all things data, Proficient in Python, SQL and Power BI ...
GitHub

[Bug] qualify row_number() produces incorrect SQL

Running the following model fails due to the generated SQL being incorrect. select id from {{ source('public_api_source', 'public_api_request_log_extended ...
GitHub

ROW_NUMBER() is affected by WHERE clause outside of subquery

SELECT * FROM (SELECT *, ROW_NUMBER() OVER (PARTITION BY a ORDER BY b) r FROM (SELECT 1 a, 2 b, 4 c UNION SELECT 1, 3, 5) o ) ra WHERE ra.r=1 AND c=5 results in a,b,c,r = 1,3,5,1. Removing the 'AND ...
WLKY

Whiskey Row now complete thanks to addition of Number 15

ATTRACT MORE PEOPLE DOWNTOWN. THE FINAL SLOT ALONG MAIN STREET’S WHISKEY ROW IS NOW COMPLETE WITH THE ADDITION OF NUMBER 15 AND OWNER SPENCER FRANK BELIEVES THIS IS JUST WHAT THE HISTORIC STREET WAS ...