/explore
|
You are here 
|
explainextended.com | ||
| | | | |
hakibenita.com
Getting the last value of a group in an aggregated query in PostgreSQL is a challenging task. In this article we present a simple way to get the first or last value of a group using group by. |
|
| | | | | ||
| | | | |
michaelerasm.us
One of the coolest things I learned about in my Redshift journey has been Window Functions. Although Window functions aren’t a novel feature and exists in other SQL databases, they are a ... |
|
| | | | | ||
| | | | |
andreabergia.com
In this post, we're going to discuss a very useful SQL extension to work with hierarchal queries. This is sadly only implemented by Oracle and although a few other databases support it as well, it won't work in PostgreSQL, MySql nor SQL Server. The dataset Link to heading Let's create a very simple hierarchal dataset to work with. |
|
| | | | | ||
| | | | |
bobrubocki.wordpress.com
I'm happy to submit this post as part of the T-SQL Tuesday series, started byAdam Machanic.I'm particularly happy because my colleague and friend, Matt Gordon, is hosting this month. Thanks, Matt!The Shiny New SQL Server Toy I want to share is temporal tables. Temporal tables are new to SQL Server with the 2016 release, and... |
|
| | | |||
