SQL query to track number of times a id has changed
I am using SQL in databricks notebook.I have a table called change_table
. This table keeps track of all changes that occurs to an id, along with other columns. The result of this change may or may not result in change of the id itself.