SQL tricky Query | 1- Reset Running Total When negative | 2 - Reset based on column value | FAANG

In this tutorial, we discuss two scenarios and write SQL Queries to reset running total. Scenario 1 - Reset when running total is negative Scenario 2 - Reset based on a column value The practice data and SQL statements are available here - Stackoverflow post for related approach - How to calculate running total? How to install SQL Server for practice? Check out the complete list of SQL Query Interview Questions - Best Data Science / Analytics / SQL courses Learn SQL Basics for Data Science Specialization Data Science Fundamentals with Python and SQL Specialization Python for Everybody Specialization Google Data Analytics Professional Certificate Coursera Plus - Data Science Career Skills Please do not forget to like, subscribe and share. Need a break from all the SQL talk? Why dont' you follow us on our new travel photography instagram account here - For enrolling and enquiries, please contact us at Website - Facebook - Linkedin - Email - learn@