Get your free certificate of completion for the My SQL Basics Course, Register Now: http://glacad.me/MySQLCourse

SQL is the standard language for Database Management System. It is used for storage, manipulation and retrieval of data in databases. There are so many features in MySQL that make our task so easy. So, In this tutorial we will be discussing one such concept called Group By and Having Clause in MySQL.

The GROUP BY statement as its name suggests, it groups the rows having the same values as summary rows. For instance, finding the number of classrooms in a particular school. It is used to group the result. The GROUP BY statement is most commonly used with aggregate functions such as COUNT, MAX, MIN, SUM, AVG etc. HAVING clause acts as a replacement for WHERE keyword because it can’t be used with the Aggregate functions.

HAVING clause is used for placing conditions on the groups created by GROUP BY statements. HAVING clause mainly helps us to identify the conditions that need to be fulfilled for having a particular group in the result. To know more about this amazing concept which makes our work so easy and interesting, Watch the complete tutorial.

Following pointers will be covered in this video:
00:00:00 Introduction
00:01:00 Group By Statement
00:02:49 Demo for Group By Statement
00:23:17 Having Clause Statement
00:24:08 Demo For having Clause

Visit Great Learning Academy, to get access to 80+ free courses with 1000+ hours of content on Data Science, Data Analytics, Artificial Intelligence, Big Data, Cloud, Management, Cybersecurity and many more. These are supplemented with free projects, assignments, datasets, quizzes. You can earn a certificate of completion at the end of the course for free. https://glacad.me/3duVMLE

Get the free Great Learning App for a seamless experience, enroll for free courses and watch them offline by downloading them. https://glacad.me/3cSKlNl

About Great Learning:
- Great Learning is an online and hybrid learning company that offers high-quality, impactful, and industry-relevant programs to working professionals like you. These programs help you master data-driven decision-making regardless of the sector or function you work in and accelerate your career in high growth areas like Data Science, Big Data Analytics, Machine Learning, Artificial Intelligence & more.

- For more interesting tutorials, don't forget to subscribe to our channel: https://bit.ly/2s92TDX

- Learn More at https://www.greatlearning.in/

For more updates on courses and tips follow us on:

- Telegram: https://t.me/GreatLearningAcademy
- Facebook: https://www.facebook.com/GreatLearningOfficial/
- LinkedIn: https://www.linkedin.com/company/great-learning/

- Follow our Blog: https://www.greatlearning.in/blog/?utm_source=Youtube
#GroupByMySQL #HavingConceptMySQL #MySQL #GreatLearning