T-SQL Window Functions
T-SQL Window Functions
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.
PRP: 220.85 Lei
Acesta este Pretul Recomandat de Producator. Pretul de vanzare al produsului este afisat mai jos.
198.76Lei
198.76Lei
220.85 LeiLivrare in 2-4 saptamani
Descrierea produsului
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.
Detaliile produsului