Group by in sql server - Part 11

In this video we will learn
1. Grouping rows using GROUP BY
2. Filtering Groups
3. Difference between WHERE and HAVING clause in sql server

Text version of the video

Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help.

Slides

All SQL Server Text Articles

All SQL Server Slides

All Dot Net and SQL Server Tutorials in English

All Dot Net and SQL Server Tutorials in Arabic

[EngraverBG]

Perfect as always.

Both the main course and the Interview Questions are made Perfect.

My proposal is to expand the number of series with one "Exercise".

Every Lesson in it have to cover some part of Lessons from the Main course (because they are grouped) by solving some kind of problem discussed in this group.

I think that such "Exercise" part will be very useful and will expand the "Interview Questions" ones.

This is just a proposal :)

[darshilshah]

Simply telling. He is the GOD of MSSQL. No extra single word, no extra shitty explanation.
To the point with the perfect example.
Hope you live long and share your knowledge.
Thank you, Sir. I appreciate your videos.

[BrianHoard]

Although this video is 9 years old, I found it exactly what I needed for my class. After reading the assigned material and scouring the internets for 2 days, I still could not understand group by. Until I found this video with perfect explanation. Thank you for explaining it so well!

[Csharp-video-tutorialsBlogspot]

Thank you very much for taking time to give feedback. In the description of this video, I have included the link for ASP .NET, C#, and SQL Server playlists. All the videos are arranged in logical sequence in these playlists, which could be useful to you. Please share the link with your friends who you think would also benefit from them. If you like these videos, please click on the THUMBS UP button below the video. For email alerts, when new videos are uploaded, you may subscribe to my channel.

[vinodp]

You are making Indians proud everywhere when it comes to the learning of Microsoft tech stack.

[daniel]

He teaches us SQL and how to think also! One one the most useful YouTube channels out there. Congratulations!

[SuperGojeto]

Was searching for the difference between where and having clause. Clearly explained. Great job!!!

[Vi.Verse]

Your teaching style is awesome!! By far the best SQL tutorials I have come across.

[perfectgaming]

Great Video! I couldn't find the table so I made it for anyone wanting to follow along.
CREATE TABLE tblEmployee (ID INT, [Name] VARCHAR (25), Gender VARCHAR (25), Salary INT, City VARCHAR (25) )
INSERT INTO tblEmployee (ID, [Name], Gender, Salary, City)
SELECT 1, 'Tom', 'Male', 4000, 'London' UNION
SELECT 2, 'Pam', 'Female', 3000, 'New York' UNION
SELECT 3, 'John', 'Male', 3500, 'London' UNION
SELECT 4, 'Sam', 'Male', 4500, 'London' UNION
SELECT 5, 'Todd', 'Male', 2800, 'Sydney' UNION
SELECT 6, 'Ben', 'Male', 7000, 'New York' UNION
SELECT 7, 'Sara', 'Female', 4800, 'Sydney' UNION
SELECT 8, 'Valarie', 'Female', 5500, 'New York' UNION
SELECT 9, 'James', 'Male', 6500, 'London' UNION
SELECT 10, 'Russell', 'Male', 8800, 'London'

SELECT *
FROM tblEmployee

[thinnongthi]

Hi Venkat My name Thin. I would like to say thank you for your Videos, that very easy to understand. Please make more Video like Advance for SQL. You are the Best teacher in me. Best Regards from Viet Nam

[MrFison]

The best SQL tutorials that I have seen on YouTube
Clearly explained and with details of the performance differences
Once I have a question in my mind the next words - is an answer )) Great job, man
Thank you

[claudiaarcand]

excellent as usual. I have to get prepared for my intership. Im french canadian and my internship is going to be in an American enterprise. I have to improve my english and get used to SQL server. Im well served with your tutorials! Your explanations are detailed and so clear, it is a pleasure to follow your course. Thank you so much!

[mouradbarakat]

Thanks a lot for the video, one of the Best on U-Tube.
I wanted to emphasize the difference between WHERE and HAVING, it's not a mater of performance at all, but they have a totally different meaning and they do NOT replace each other. The WHERE keyword will filter the rows first then do the GROUPing, but HAVING will filter output of the GROUPing! They produced the same result in this specific example and that is only a coincidence.

[collinsgift]

I'm so glad I came across this channel, it's been a blessing....thank you so much

[Aionjimme]

Wow thanks I was stuck on this part for like 2 hours straight, your video saved me :))

[baluzen]

I really understood the concepts of where and having  clause . Thanks to your good explanation. And i am sure who looks into your sql videos definitely will get full and thorough knowledge.

[Nikita]

Wonderful explanation, really appreciate your work, how simply you explain all things. Please give more such treats ...! Thank you so much.

[snehachimegave]

Every Second of this video is fruitful... You are just Awesome, Supreme, Matchless❤️👍🏻🙌🏻....Million Thanks for this series.

[monikashah]

These videos are awesome !!! Very detailed & thorough !!! Thank you so much !!!

[darpansaxena]

One of the best video, best ever explanation I have ever seen. Thank you for this lovely and fruitful video.
The way of your explanation is outstanding and you cover all the related things.
Amazing and only and only finest one among all the sql videos provided in internet.
Thank you