Скачать или смотреть Did You Just Break Your SQL Query? Here’s How to Tell

📝 Get my free SQL Cheat Sheets: https://databasestar.mykajabi.com/lpk...
🎓 Master SQL Fundamentals: https://databasestar.mykajabi.com/sql...

If you make changes to an SQL query, you're probably wondering if the results are still correct.
It's easy to make a change, but it's hard to know if this change has broken something in your results.

In this video, I'll show you a method to compare the results of your original query and your new query, so you can easily see if your new query has broken something or showing the wrong results.


⏱ TIMESTAMPS:
00:00 - Change your SQL
01:09 - Create a temp table
02:03 - Compare data
04:52 - Check the other direction
06:17 - Combine into one query
08:01 - Easier with a CTE

🔗 VIDEO LINKS:
Scripts for this video: https://github.com/bbrumm/databasesta...