Recent Articles

SQL,

Redshift Window Functions Advanced Use Cases

Merging time-based events into periods Thanks to our previous posts about the window functions, Introduction to Window functions on Redshift and Data exploration with Window functions on Redshift, you should…

Jiří Mauritz August 3, 2017

SQL,

Data Exploration with Window Functions on Redshift

We have already introduced the main concept, syntax and simple examples of window functions applied to practical problems. In this post, we will go through some more advanced window functions…

Jiří Mauritz July 26, 2017

SQL,

Introduction to Window Functions on Redshift

Benefits of Window Functions Window functions on Redshift provide new scope for traditional aggregate functions and make complex aggregations faster to perform and simpler to write. Window functions also allow…

Jiří Mauritz July 11, 2017

SQL,

Tricks with SQL: Beware of the Predicate in the Outer Join

Today we will have a look what happens when we place a filter condition into an outer join. We will also have a look at how this compares to placing…

Uli Bethke November 21, 2012

SQL,

Uses of the modulo operator: How Oracle mod can make your life easier.

You may ask, what the heck is modulo? Well, below is an easy to understand definition. "Modulo basically means keep taking the second number away from the first number. When…

Uli Bethke October 11, 2012

SQL,

LISTAGG with CLOB? String aggregation exceeding 4000 characters with XMLAGG.

We all know that the Oracle LISTAGG function does not support the CLOB datatype. In my opinion this is a severe limitation of LISTAGG (and BTW also of PIVOT and…

Uli Bethke April 23, 2012