#throwback Still using aggregates where window functions shine? 📈 Jan Suchánek explains analytical functions in PostgreSQL and shows how rewriting queries can drastically reduce response times.
▶️ Watch now! www.youtube.com/watch?v=cXIR...

#PostgreSQL #PGDay #PPDD #SQL #WindowFunctions

📊 MySQL ORDER BY + Window Functions = Smarter Analytics

Need advanced analytics in MySQL? Try ORDER BY with window functions like ROW_NUMBER, RANK, and NTILE.
👉 Quick guide: is.gd/iGx0Ju
🔧 Try dbForge Studio for MySQL: is.gd/ymqNRj

#MySQL #WindowFunctions #dbForge

Using Ecto Multis, Oban, and transaction callbacks to isolate concepts YouTube video by ElixirConf

Came for Ecto Multi + Oban and side-effects, stayed on window functions 👀

#ElixirLang #Ecto #windowfunctions #postgres

www.youtube.com/watch?v=hHQ5...

🧠 Exemplo de Window Functions no SQL para Análise de Dados! 📊
SUM(valor) OVER (ORDER BY data_venda)
Vai somar acumulando os valores com base na data

#SQL
#DataAnalytics
#WindowFunctions
#SQLTips
#Bi