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.