I don't usually comment on tutorial videos, but this video is so clear I just want you to know how helpful you are for beginners like me
@DatabaseStar
Жыл бұрын
Glad it was helpful!
@rickvazquez6578
Жыл бұрын
Mate you clarified something for me, I was wondering why I always had to add every other column I had to group by :) plenty helpful keep up the great tutorials!😃
@DatabaseStar
Жыл бұрын
Glad it helped you understand the concept further!
@sebastianhernandez9631
10 ай бұрын
I'm preparing for DP-900 exam and I was having a hard time with the Group By statement and aggregate functions. This video has helped me understand it perfectly. Thanks! Subscribed.
@DatabaseStar
10 ай бұрын
Thanks! I'm glad the video helped you understand it.
@ordinaryperson-my7qr
Жыл бұрын
thanks sooooo much dude i NEVER wrapped my head around how this works now i am crystal clear :)
@DatabaseStar
Жыл бұрын
Awesome, good to hear!
@lexiwhitmore2197
Жыл бұрын
This was helpful and clear, thank you! I liked your group by question, because I tend to create a question like that when I'm struggling to formulate the correct query.
@DatabaseStar
Жыл бұрын
Glad it was helpful!
@manojkumar-yc4xq
3 ай бұрын
What a clean and easy way of explaining the fact. Thank you SIR.
@DatabaseStar
3 ай бұрын
You're welcome!
@user-iv9sh9fc3c
3 ай бұрын
you are definitely a database star. Thank you
@DatabaseStar
3 ай бұрын
Thanks!
@diamondsandlipgloss
2 ай бұрын
1:18 why do we need the parenthesis around the asterisk in the SELECT FROM statement?
@DatabaseStar
2 ай бұрын
Good question. It's because the word COUNT is a function, and functions need to have brackets at the end of the name so they can run. Inside the brackets for functions, we specify parameters, such as values or columns to be processed by the function. The COUNT function can count columns: for example, COUNT(first_name) counts the number of first_name values that are not NULL. The asterisk is a different parameter to the COUNT function, and it means "count the entire row". So, COUNT(*) means count the entire row. Hope that answers your question.
@diamondsandlipgloss
2 ай бұрын
@@DatabaseStar got it, SO VERY helpful i don't know how i'll remember all of this 🤦🏾♀️
@COOKINGBIRD
Жыл бұрын
Your SQL video was exactly what I needed. Thank you for explaining it so clearly. 😄🎬💻🔍
@DatabaseStar
Жыл бұрын
Thanks, glad you liked it!
@akanirokingsley3304
5 ай бұрын
your explanations resonates with me on a deep level.
@DatabaseStar
5 ай бұрын
This makes me happy. I’m glad the explanations help you!
@khawar1690
4 ай бұрын
Very well explained. Aggregated function was helpful to me. Thank you
@DatabaseStar
4 ай бұрын
Glad it was helpful!
@thebigcheese1153
5 ай бұрын
Thanks for actually explaining it.
@DatabaseStar
5 ай бұрын
You’re welcome!
@aashutosh937
Жыл бұрын
Thank you for explaining it in such a simple way :)
@DatabaseStar
Жыл бұрын
You're very welcome!
@Aliyaaugust
3 ай бұрын
Great explanation 💯🤍🤍🤍
@DatabaseStar
3 ай бұрын
Thanks!
@tsunamio7750
8 ай бұрын
Nice video! Your indentation hurts me, but thank you for this video; It is very well presented!
@DatabaseStar
8 ай бұрын
Thanks! Do you prefer a different style of indentation for SQL code?
@leonsant-jennings7417
Жыл бұрын
Cheers boss, I knew I had to use Group By but I didn't fully understand why.
@DatabaseStar
Жыл бұрын
Thanks, glad it was helpful!
@nickjoseph2711
2 жыл бұрын
Super helpful. First slide's visual really helped...
@DatabaseStar
2 жыл бұрын
Glad you liked it!
@douaz6905
15 күн бұрын
Thank you very much
@DatabaseStar
15 күн бұрын
You’re welcome!
@DCh-ks6ug
6 ай бұрын
that waaaaas veeeeery helpful thaaaaaank you
@DatabaseStar
6 ай бұрын
You're welcome!
@dragoneer8756
9 ай бұрын
Good to know, most important part was that the field selected should be in the group by clause. THey completely left that out in class
@DatabaseStar
9 ай бұрын
Glad you liked the video. Can’t believe they left that out of your class!
@dragoneer8756
9 ай бұрын
@@DatabaseStar It was a very rushed class tbh. Teaching finished at the beginning of November so I'm self-studying for finals😅😅
@mrjump6745
Жыл бұрын
very detailed. clear. beautiful thanks ALOT really helpful
@DatabaseStar
Жыл бұрын
Glad it was helpful!
@jatinsharma8353
Жыл бұрын
awesome most easiest explanation. Thanks man
@DatabaseStar
Жыл бұрын
Glad it helped!
@higiniofuentes2551
10 ай бұрын
Thank you for this very useful video!
@DatabaseStar
10 ай бұрын
No problem, glad you liked it!
@user-vz7qd1br5o
6 ай бұрын
thank you.
@DatabaseStar
6 ай бұрын
You're welcome
@Mike-vj8do
10 ай бұрын
real good video, thank you!
@DatabaseStar
10 ай бұрын
You’re welcome!
@arvindt553
6 ай бұрын
Can you please give an example with two tables that have many to many relationships
@DatabaseStar
6 ай бұрын
Good idea, I can do that.
@salmaa7810
Жыл бұрын
very helpful; thank you!
@DatabaseStar
Жыл бұрын
Thanks!
@mustaphaelouahabi9316
Жыл бұрын
👋 Bravo! A very well-explained demo!
@DatabaseStar
Жыл бұрын
Thanks!
@mustaphaelouahabi9316
Жыл бұрын
@@DatabaseStar....... You're very welcome! Can you please make a crash course about "MySQL for Advanced Data Analytics"?
@hfghffggjngyh4754
21 күн бұрын
thax
@DatabaseStar
20 күн бұрын
You're welcome
@SpringRain23
Жыл бұрын
Excellent video !
@DatabaseStar
Жыл бұрын
Glad you liked it!
@bot299i82
3 ай бұрын
😂 nobody understand group by
@DatabaseStar
3 ай бұрын
It can be hard to understand
@mostafa2199
2 жыл бұрын
thanks it really helped
@DatabaseStar
2 жыл бұрын
Glad it helped!
@Entertainmentmod
2 жыл бұрын
Very good information
@DatabaseStar
2 жыл бұрын
Thanks!
@swan_oahu
Жыл бұрын
Thank you 👍
@DatabaseStar
Жыл бұрын
No worries!
@vaylx2253
2 жыл бұрын
Thanks for that.
@DatabaseStar
2 жыл бұрын
Glad it was helpful!
@statesman6379
Жыл бұрын
My only question is if you have 3 columns in the Select Statement with an aggregate function, for example, is it mandatory to always include all 3 columns in the group by clause? And if not, then how do we know which of the 3 columns must be included?
@DatabaseStar
Жыл бұрын
Good question. Yes, it's mandatory to include all three columns in the Group By clause. If you don't, you'll get an error about columns in the Select not in the Group By (the exact error will depend on the database vendor). The only exception is some versions of MySQL allow you to have a mismatch between the Group By and the Select. But you'll get a result that won't be correct, such as showing the first group only but the aggregate function on all rows.
@statesman6379
Жыл бұрын
@@DatabaseStar Thanks for the awesome reply! I just subscribed.
Пікірлер: 84