Continuing the T-SQL journey with OVER and RANK

Continuing our T-SQL journey, Patrick explores the use of the OVER and RANK functions in combination with common table expressions (CTE) in Azure SQL Database and Azure Synapse Analytics.

RANK (Transact-SQL)

SELECT - OVER Clause (Transact-SQL)

WITH common_table_expression (Transact-SQL)


*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.


*******************
LET'S CONNECT!
*******************


***Gear***

#AzureSynapse #AzureSQL #GuyInACube

[djkuralt]

This video deserves more likes than it's getting! I'm in an internship where I'm using T-SQL and PowerBI, and these videos are very VERY helpful!

[joeseroski]

I love the T-SQL videos. Explained in an easy, concise way.

[pieterlinden]

Since I learned T-SQL before doing DAX, I use windowing functions all the time! SUPER handy!

[bertholdflikkema]

Window functions are awesome! One tip though, you missed an opportunity to explain some new t-sql stuff ;) Since sql server 2022/azure sql, there is the new window clause. Which enables you to specify a window once and reuse it many times. When you use window functions extensively you will often see the over() part being copied many times within one statement. The window clause allows you to deduplicate your code. Would have been a nice addition for the folks already familiar with window functions.

[cooky]

Nicee! Very concise... I'm excited to see what's next!

[joeseroski]

I would love to see a video on stored procedures. What they are, why you would use them, maybe in context with Power BI or Paginated Reports.

[raymondjurado]

Getting into window functions can save a ton of time for you.

[rachwalskimarcin]

Is there a playlist with T-Sql videos?

[Anthony_Lecoq]

Great video Patrik ;) Do you know if the OVER statement can generated in power query through the query folding? Or will it be in a near future ? Maybe a question for the master Alex Power?

[clairerovic]

Would use the Partition window daily. Just makes the day to day queries easy.

[valentb]

Love theese videos, but can you put and show us how you put what you write in a view or table and import it to powerbi. I know it sounds stupid but alot more people with catch on and it will bedome a smooth transition from a-b.

[JohnKpl]

When you explain it, it all seems so simple.
PS
My SQL Server uses single quotes, not double quotes. That's weird

[mszakalinski]

Just wondering if what you ve done here cant be done faster in power query in native query mode then copy paste bam, or copy paste to chat gpt to shorten/ check and bam done, aint this way a dinosour way :) ? I know not all can be done by nq but a lot