Most T-SQL developers recognize the value of window functions for data analysis calculation. But window functions can do far more than that, and optimizations in recent...
Most T-SQL developers recognize the value of window functions for data analysis calculation. But window functions can do far more than that, and optimizations in recent versions of SQL Server have made them more powerful than ever. In T-SQL Window Functions: For Data Analysis and Beyond, renowned T-SQL expert Itzik Ben-Gan introduces breakthrough techniques for using window functions to handle many common T-SQL querying tasks with unprecedented elegance and power.
Ben-Gan first explains why window functions can often be a far better solution than traditional predicate-based approaches. Next, using extensive code examples, he guides you through each type of window function: Aggregate, Ranking, Distribution and Offset. You'll find detailed coverage of ordered set functions (including SQL Server 2017's STRING_AGG); plus an extensive section on optimization. The book concludes
Chýba alebo je nepravdivý niektorý dôležitý parameter? Uvedené informácie sú len orientačné, pred nákupom vo vybranom obchode odporúčame overiť, že predávaný model má kľúčové vlastnosti podľa vašich požiadaviek. Aj keď sa snažíme o maximálnu presnosť informácií, bohužiaľ nemôžeme zaručiť 100% správnosť. Ceny produktov sú vrátane DPH.
