Where vs Having in SQL | MySQL for Beginners
In this lesson we are going to learn about group by and Order by in SQL
📖 Download Having vs Where Query file from Github : https://github.com/AtulKadlag/MySQL_B...
Resources:
Udemy Courses:
📖 Take my Full Power BI course here - https://www.udemy.com/course/master-m...
📖 Take my Full SQL Course here - https://www.udemy.com/course/complete...
📖 Take Excel to pro course here - https://www.udemy.com/course/pro-excel/
Often while working on SQL projects, we have some specific requirement like we need to filter the data on aggregated columns in SQL and also sometime we just need to filter data simply.
Every requirement is different, and HAVING and WHERE is used for this, but when to use HAVING clause and when to use WHERE clause, that we need to understand. The difference between HAVING clause and WHERE clause is important to understand so that in real time projects we can use it very well. Just understand this practically with examples.
difference between HAVING clause and WHERE easily explained.
difference between having vs Where
---------------------
All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for
