Moving Average in PostgreSQL
Assume that you have the table mytable with the following fields: Date Store_ID Sales And you would like to get …
Categories : SQL
How to search JSON for a string in Prostgres
This is useful when we are dealing with big nested JSON’s in our data and we just want to look …
How to Flatten an Array in PostgreSQL
Assume that we are dealing with the following table called tbl and we can to flatten it as follows: Notice …
How to Generate Date Series in Redshift
In a previous post, we have provided an example of how to generate date series in PostgreSQL. Let’s see how …
How to Generate Date Series in PostgreSQL
In many SQL statements, there is a need to generate “Date Series” and then run some left join statements in …
