Need to capture hierarchal relationships or data existing across multiple rows in a single table within a single row? This is a job for the SELF JOIN.

At SQL Short Reads, I demonstrate how to capture the classic hierarchical relationships between employees and managers and product categories using a SELF JOIN.

I also showcase how you can bring together data existing across multiple rows into one row by taking advantage of the mathematical relationship between them in an exercise using a mortgage’s step-rate addendum or schedule.

Learn more at SQL Short Reads.

#SQL #DataAnalytics #DataEngineering