|
You are here |
36chambers.wordpress.com | ||
| | | | |
andreabergia.com
|
|
| | | | | Window functions are an extremely powerful powerful part of the SQL 2003 standard, supported by most modern releases of databases such as Oracle 8+, Postgres 9.1+, SQL Server 2005+ and others. Sadly neither SQLLite or MySql seem to support them yet, but if you are working with a database where they are available, do use them: they can make your life a lot easier. Generally, with window functions, you can write simpler and faster code than you would without. | |
| | | | |
boringsql.com
|
|
| | | | | Unlock powerful data analysis in PostgreSQL with window functions. Go beyond aggregates to rank, calculate running totals, and compare rows directly within your queries. | |
| | | | |
sqlserverfast.com
|
|
| | | | | This is part twenty-six of the plansplaining series. And already the fourth episode about window functions. The first of those posts covered basic window functions; the second post focused on fast-track optimization for running aggregates, and the third post explained how the optimizer works around the lack of execution plan support for UNBOUNDED FOLLOWING. But... | |
| | | | |
compositecode.blog
|
|
| | | I've worked with (** references at end of article) a number of Apache projects over the years, often pretty closely; Apache Cassandra, Apache Flink, Apache Kafka, Apache Zookeeper and numerous others. But the last few years I've not been immediately hands on with the technology. A few questions popped up recently, that fortunately I was... | ||