Avancerad sökning
Din kundvagn är tom
Ändra i din kundvagn Gå till kassan
T-SQL Window Functions
  • Bandtyp: Häftad
  • Språk: Engelska
  • Utgiven: 201911
  • Antal sidor: 352
  • Upplaga: 2 ed, 
    Vikt i gram: 581
  • ISBN10:0135861446
  • ISBN13:9780135861448

T-SQL Window Functions

(Häftad)
Beskrivning:

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 with roughly 100 pages of real T-SQL solutions using window function approaches - including techniques invented by the author and available in no other book.

Kundrecensioner och bloggar

Sök fler böcker:

Kunder som köpt denna bok har
även köpt:
Pris195 kr
Lägg i kundvagn Pris165 kr
Uppgång och fall
av Strömquist, Liv
Lägg i kundvagn Pris189 kr
Miniatyrmakaren
av Burton, Jessie
Pris54 kr
Min mors självbiografi
av Kincaid, Jamaica
Pris203 kr