Перейти к содержимому

The Magic of Window Functions in Postgres

EDB

0:00 / 0:00

The Magic of Window Functions in Postgres

4 036 просмотров · 6 лет назад
EDB
11,1 тыс. подписчиков
4 036 просмотров · 6 лет назад
For more Postgres webinars​​​​​, visit: https://okt.to/1EMXGJ ------------------------------------------------------------------------------- Window functions are often used to simplify complex queries and for data analytics. They allow analysis that is normally performed in client applications to be more efficiently processed by the database server. This presentation explains the many window function facilities and how they can be used to produce useful SQL query results. In this webinar you will learn: The basics of window functions Window function syntax Window syntax with generic aggregates Window-specific functions Window function examples ---------------------------------------------------------- For more #webinars​​​​​, visit https://okt.to/wSA9p1 Download free #PostgreSQL​​​​​ whitepapers: https://okt.to/9SniZy Read our #Postgres​​​​​ Blog https://okt.to/NSirVs Follow us on Facebook at https://okt.to/CT4VsK Follow us on Twitter at https://okt.to/S5JjWy Follow us on LinkedIn at https://okt.to/ke2hC0 Reach us via email at marketing@enterprisedb.com