Group By and Having Clause in SQL | Aggregate functions in SQL | SQL Tutorial for Beginners in Hindi

In this video we have discussed very important concepts in SQL i.e. aggregate functions, group by clause and having clause in SQL. In this video we have seen many examples where we can use various aggregate functions like MIN, MAX, COUNT, SUM, AVG. Also we have seen where to use group by and where to use Having. Please like and share this video with your friends. What is a Scalar function : 0:58 What is Aggregate function: 02:00 MIN() : 2:55 MAX() : 03:32 SUM(): 03:58 COUNT(): 04:36 AVG() : 05:34 GROUP BY clause: 06:09 HAVING clause: 12:02 Please like & share the video. Subscribe the Channel to keep watching interesting videos helpful for your career growth: https://youtube.com/channel/UCaoCTb7FoUYOo9R8r_X9YHg?sub_confirmation=1 -------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------- Checkout different playlists: PLSQL Tutorial : https://youtube.com/playlist?list=PLKVxK2jv1oA-LwzbMlOFZS-CgbucH5OhQ Learn DBMS & SQL : https://www.youtube.com/playlist?list=PLKVxK2jv1oA9Ow28rg__JaBWjJQtoPyu6 SQL Interview Questions and answers: https://www.youtube.com/playlist?list=PLKVxK2jv1oA_t7KqNfdUgNC9x54vymFbb Java Interview Questions and Answers : https://www.youtube.com/playlist?list=PLKVxK2jv1oA9NlG3QXy18ov1oGl7iJk_6 IT Career guidance: https://www.youtube.com/playlist?list=PLKVxK2jv1oA93GQr8gbmdtU0u1AMKnsLe Interview Tips : https://www.youtube.com/playlist?list=PLKVxK2jv1oA-_-h-qPt1RiI926j9VxFYa IT Essentials and Tricks : https://www.youtube.com/playlist?list=PLKVxK2jv1oA-Y33bY2xUSRSqX3fUtSODw -------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------- Checkout Important videos : Top 30 SQL Queries Interview Questions and Answers : https://youtu.be/sa6_kqlglLs Top 50 SQL Concepts Interview Questions and Answers : https://youtu.be/UZAqMAzCZss SQL JOINS : https://youtu.be/isQ8up-zUPY SUB QUERY : https://youtu.be/EQbhKjBmW88 Employee earning maximum salary in each department query : https://youtu.be/Q9bIOBds0lo How to delete duplicate rows from any table (2 different solutions): https://youtu.be/0Drirbci1fM How to find Nth highest salary (3 different solutions): https://youtu.be/lphtqFZ-iQc Tricky SQL Queries Part1 : https://youtu.be/-JwSWMm0E40 Basics of Database : https://youtu.be/xRte0DGB5KM SQL OPERATORS : https://youtu.be/VXDk8jXJN3Y AGGREGATE FUNCTION: https://youtu.be/SpvTUjPfV20 GROUP BY : https://youtu.be/tF_SU_5QXuU Solve any Date related query : https://youtu.be/a5N995aY9Fo How to use Substring : https://youtu.be/-O--KRzobas How to practice SQL Queries in local / Install Database in local : https://youtu.be/2RLyGa9dr8A IT Jobs without Coding : https://youtu.be/zTHRaNRxtXc -------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------