T-SQL Window Functions

T-SQL Window Functions

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.
 

Book Now Learn More About Training Classes