A (somewhat opinionated) list of SQL tips and tricks that I've picked up over the years. There's so much you can do with SQL but I've focused on what I find most useful in my day-to-day work as a data ...
This is a simple solution to compare two versions of an SQL table or view. It allows you to see... Which rows changed What columns changed (including previous and new values) Which rows were added And ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback