Manoj GangerCorrelated subqueriesMost SQL code you encounter or write is probably simple or maybe a bit complex on joins, filters, or at the most may contains windows…Jan 8, 2021Jan 8, 2021
Manoj GangerShort and Sweet Data PipelineI came across a problem from a code challenge website and thought of doing this using decorator functionality in Python.Jul 9, 2020Jul 9, 2020
Manoj GangerFrom SQL to Pythonic PowerIn this blog, I will write a simple SQL and show how the same results can be achieved in Python. This is just to demonstrate Pythonic way…Jun 14, 2020Jun 14, 2020
Manoj GangerFilling Gaps In Dates Using SQLWhen dates are not continuous, this article would help to know quickly the value of metrics on the missing dates. Huh! well, let’s look at…May 22, 2020May 22, 2020
Manoj GangerPythonic Way To Iterate & look aheadThere are lots of cool tricks in Python. In this article, the highlight is to look ahead in iterable for some very specialized processing.May 20, 2020May 20, 2020