Kontakt
Jak nakupovat
Doručení
Nákupní rádce
Advanced SQL
Window Functions, CTEs, Recursive Queries, Ranking, Running Totals and Analytics Patterns for Real Reports
Němčina
80 b
Nové
You can write SELECT, JOIN and GROUP BY, yet the real requests keep arriving: the top orders in every region, a running total that restarts each month, a moving average, the longest streak of daily logins, everyone under a given manager at any depth. This book teaches the patterns behind those reports. You learn window functions with ranking, frames, lag and lead, then common table expressions and recursive queries for hierarchies, calendars and route searches. Later chapters cover gaps and islands, safe deduplication, top-N per group, pivots with conditional aggregation and set operations. Every query was run on a small fictional shop database and the real result rows are shown, with plain notes on where database engines differ, so you can check each answer by eye.
Informace o knize
Němčina
Darujte tuto knihu ještě dnes
Je to snadné
1 Přidejte knihu do košíku a zvolte doručit jako dárek 2 Obratem vám zašleme poukaz 3 Kniha dorazí na adresu obdarovanéhoAhoj! Jsem Libroamiko, tvůj knižní rádce.
Jak ti můžu pomoct?