/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 andreabergia.com
Introduction to SQL Window Functions / 1 ยท Andrea Bergia's Website
| | 36chambers.wordpress.com
A Slice of Time: Good Use Cases - 36 Chambers - The Legendary Journeys: Execution to the max!
1.4 parsecs away

Travel
| | This is part seven in a series on window functions in SQL Server. The Road So Far To this point, we've looked at five classes of window function in SQL Server. I've given you a couple of solid use cases, but for the most part, we've focused on what the classes of window functions are....
| | vickiboykis.com
Why doesn't MySQL have window functions? | Vicki Boykis
1.4 parsecs away

Travel
| | *Updated with comments from MySQL at end of post. * I've worked with a lot of the different flavors of SQL, including Oracle, SQL Server, Postgres, and SQLite, so I thought I knew all nuances of different SQL syntaxes. But I've recently been working with a project that's using a LAMP stack, so I've gotten a lot more understanding of the MySQL's caveats. I'm working on some data manipulation that requires window functions in MySQL, and I learned the hard way that MySQL doesn't support them.
| | barneylawrence.com
T-SQL Tuesday #168 - FIRST_VALUE, LAST_VALUE and NULL Handling - Barney Lawrence - A Blog
1.9 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.
| | chasingaphrodite.com
2/21/23 at the Natural History Museum of Utah: "Chasing Shiva: The Hunt for Looted South and Southeast Asia Antiquities" | CHASING APHRODITE
10.6 parsecs away

Travel
| https://www.youtube.com/watch?v=mFVT1WZrTjo