T-SQL Window functions: for data analysis and beyond

"Most T-SQL developers recognize the value of window functions for data analysis calculations. But they can do far more, and recent optimizations make them even more powerful. In T-SQL Window Functions, renowned T-SQL expert Itzik Ben-Gan introduces breakthrough techniques for using them to han...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
1. Verfasser: Ben-Gan, Itzik (VerfasserIn)
Format: Buch
Sprache:English
Veröffentlicht: Redmond, Washington Microsoft [2020]
Pearson Education [2020]
Ausgabe:Second edition
Schriftenreihe:Professional
Schlagworte:
Zusammenfassung:"Most T-SQL developers recognize the value of window functions for data analysis calculations. But they can do far more, and recent optimizations make them even more powerful. In T-SQL Window Functions, renowned T-SQL expert Itzik Ben-Gan introduces breakthrough techniques for using them to handle many common T-SQL querying tasks with unprecedented elegance and power. Using extensive code examples, he guides you through window aggregate, ranking, distribution, offset, and ordered set functions. You'll find a detailed section on optimization, plus an extensive collection of business solutions -- including novel techniques available in no other book."--provided by publisher
Beschreibung:Includes index
Beschreibung:xiv, 327 pages illustrations 23 cm
ISBN:9780135861448
0135861446

Es ist kein Print-Exemplar vorhanden.

Fernleihe Bestellen Achtung: Nicht im THWS-Bestand!