Practice Activity - Retrieving the last row for each group in a table in SQL Server

[@Random_dudebro]

I have been looking for a way to do this for about 3 weeks for a work project and you saved me… thank you lol

[@SQLServer101]

Hi Random. I'm glad that I could help. Phillip

[@itsgroovylue]

You absolutely saved my day my friend!! Thank you!

[@krishnakamalgogoi9893]

with cte3 as
(select *,
ROW_NUMBER() over(partition by Region order by Pricedate desc) as region_rnk
from tblhouseprices)
select * from cte3
where region_rnk = 1

[@nonoobott8602]

Absolutely brilliant. This is so useful. Thanks for sharing

[@diegocosta168]

Great! Helped me a lot 👏👏👏

[@minnrick7986]

Thanks! CTE seems the most elegant to me :)

[@SQLServer101]

Thanks - I do like CTEs, as they can simplify nested subqueries - which we'll be having a look at in the next video. Phillip

[@taibabs1222]

You could also put the query into a temp table as suppose to a CTE.

[@ElWiwif]

You rock!! Thanks!!

[@danramirz]

Thanks for this video!

[@jacekk7819]

I`m not sure why but my CTE with ROW_NUMBER is faster than other two , query plan showing me 22% , 39% , 39% for query cost

[@SQLServer101]

Hi Jacek. Very interesting - it's good a) to be able to have multiple ways to do the same thing, and b) to see which is faster! Phillip

[@Mnfls]

This is 🤯

[@dangkhanhlinh476]

nice!

[@HippoAliasSkelman]

thanks a lot :)