SQL Tutorial - 26: The GROUP BY Clause

In this tutorial we'll check out the GROUP BY Clause. The GROUP BY Clause is used to get together identical data obtained in result sets. We will also briefly talk about two aggregate functions in SQL.

[bionicbeaver]

Sounds like this is being recorded in a palace - great video thanks!

[helpmore]

Thank you so much for this playlist. It is like a tree which someone planted and take care in past and now we are just enjoying the fruits and taking the advantage. Your playlist which is uploaded in past proves it as that tree. This kind of content and explanation is not found without paying any fee. THANK YOU for your efforts.

[ShortInspire]

Bro you just saved me, nice explaining and nice tutorial Thank you.

[AKASHKUMAR-zzrm]

U have nailed it sir...best tutorial on SQL on internet 🙏

[HamsterLoad]

These tutorials are so good. I don't understand how you can get dislikes :S

[madhavroar]

Thanks ! I was really confused and finally found the solution to my confusion here!!

[OrionEngleton]

Clear and concise series..This series helped get thru a rough patch.  Thank you very much sir.

[syedzubair]

hi madhur,
in the beginning of this tutorial you said group by clause has to be used, with where clause first and followed by order by clause, but you dint show any example for this..can you please..& thanks

[AddieInGermany]

That smile at 0:13, after saying 'Groping" identical data together.. Awesome tutor !! :D

[frostknight]

I have 2 questions:

1) Would you get the same result if you use COUNT(title)?

2) Why can't you use SUM(*)?

[ae]

what about using count(title) instead of count(*). Are both correct ?

[ShootThemLater]

Could you please add the construction of the table and the insertion of the data so we can share the same info. I'm too lazy to make a lot of inserts. Thank you.

[gaurabdas]

where is vedio no. 27, 28, 29, 30 i cannot find dem please provide me with theair link..and please tell my an easy way to get all these videos in a sequential manner..
 

[atkuriajaykumar]

thankyou sir you explanation is very good

[dinnusebastian]

How do we get the rows that corresponds only to SQL group...Means I need every coloum and its rows that belong to a particular group.

[harshakallori]

Sir, u said that where clause is not optional for executing group clause but u haven't mentioned where clause in the query.

[nkrawal]

how to use group by without aggregate function in select list

[chandradeepchakravarti]

Does count function return the the number of columns that has the value more than one ? I mean what if you have uploaded only one video of C . The number of video of C is not fetched by count function then

[marijuanastoner]

WE can also write COUNT(tittle) the same also returned the desired output or is there something wrong in that

[haaa]

I have a question I realized in the sum group that the result of shell scripting was 16.88 my qustion is how to get the correct format for minutes and seconds