Explore >> Select a destination

You are here

 36chambers.wordpress.com
A Slice of Time: Good Use Cases - 36 Chambers - The Legendary Journeys: Execution to the max!
| | boringsql.com
Gentle Introduction to Window Functions in PostgreSQL | boringSQL
2.8 parsecs away

Travel
| | Unlock powerful data analysis in PostgreSQL with window functions. Go beyond aggregates to rank, calculate running totals, and compare rows directly within your queries.
| | andreabergia.com
Introduction to SQL Window Functions / 1 ยท Andrea Bergia's Website
1.1 parsecs away

Travel
| | 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.
| | barneylawrence.com
T-SQL Tuesday #168 - FIRST_VALUE, LAST_VALUE and NULL Handling - Barney Lawrence - A Blog
2.7 parsecs away

Travel
| | FIRST_VALUE and LAST_VALUE had limited uses when they were first released to the world back in 2012, but with the introduced of the ability to ignore nulls in SQL Server 2022 they become a lot more useful. Let's take a look at some examples of why.
| | reclaimingparadise.wordpress.com
August 8, 2025 - Reclaiming Paradise
11.3 parsecs away

Travel
| 1 post published by Reclaiming Paradise on August 8, 2025