Session Title: T-SQL Window Functions
Speaker: Martin Catherall

Abstract: Window Functions first emerged with the 2005 release and were enhanced in 2012.

They provide a window over the result set and the ability to access data other than the current row.

This means that somethings that may – at first – seem like they need row-by-row processing can be done in one single set-based operation.

The set of window functions available also includes server analytical functions that give the ability to perform statistical analysis.

Come along to this session and see a deep dive into window functions and learn how their use will add to your ability to process data and write more efficient and cleaner queries.

300+ sessions are now available on-demand from Data Platform Summit 2021 & 2020 at no cost. Browse all sessions.

Stay tuned, more learning coming your way.