O'Reilly logo

Tribal SQL by Matt Velic, David Tate, Shaun J Stuart, Wil Sisney, Mark S Rasmussen, Bob Pusateri, Dev Nambi, Colleen Morrow, Stephanie Locke, Chuck Lathrope, Tara Kizer, Kevin Feasel, Diana Dee, John Barnett, Dave Ballantyne

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Windows Functions in SQL Server 2012

Dave Ballantyne

If you are a SQL Server 2012 developer, you may not be so interested in Always-on High Availability and “Big Data,” the focus of the marketing hype for SQL Server 2012, but you'll love the enhancements to the SQL Windows functions. This is the real big-ticket item.

SQL Server 2005 ushered in the first ANSI-standard Windows ranking and aggregate functions, along with the OVER clause, which allowed us to apply the functions across each row in a specified window/partition of data. The use of OVER alongside the new Common Table Expressions (CTEs), made for a revolutionary change in the way that one could develop T-SQL solutions. Still, certain procedures, such as the rolling balance calculation, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required