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

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 ...
GitHub

sp_BlitzCache @SortOrder = 'executions' only returning 1 row when duplicate hashes exist

Dev branch, most current code, VersionDate = 20190101 (also verified that it happens in the master branch from the Jan release.) Run sp_BlitzCache @sortorder = 'executions' and it only returns one row ...
findnerd.com

How to display SQL row data as a column wise with user specific column name

Hello all, The below tutorial will help you in displaying SQL row data as a column wise with user specific column name. here, I've a table with #Temp1 name that contains the following columns Id, ...