SQL Tutorial - 26: The GROUP BY Clause

[@helpmore9389]

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.

[@bionicbeaver6636]

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

[@ashiksaleem360]

Or in a bathroom

[@AKASHKUMAR-zz5rm]

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

[@ShortInspire0]

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

[@HamsterLoad]

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

[@LittleNoob131]

He gets dislikes because there are people who hit the dislike button. KZbin has a counter for dislikes too. Every time a person clicks the thumbs down icon, a dislike is added. I hope I am clear.

[@kushalbaldev8490]

@@LittleNoob131 😂

[@madhavroar]

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

[@GauriSurve3]

Now I shall pass! Bless you man...

[@OrionEngleton]

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

[@madhurbhatia89]

I'm glad you found my work useful. I plan to record and share loads of tutorials on several other subjects pretty soon. Thanks for watching the tutorials in this series.

[@polnapanda4934]

how is going your journey with programming?? :)

[@AddieInGermany]

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

[@frostknight1347]

I have 2 questions: 1) Would you get the same result if you use COUNT(title)? 2) Why can't you use SUM(*)?

[@syedzubair1387]

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

[@ikkeshri]

Its clear my doubt , thank you

[@OutsideNormalMoralConstraints]

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.

[@gaurabdas2430]

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..

[@dinnusebastian4615]

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.

[@ae1550]

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

[@atkuriajaykumar3701]

thankyou sir you explanation is very good

[@HussainAhmed-bl1ku]

Useful enough to learn

[@harshakallori4083]

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

[@chandradeepchakravarti2742]

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

[@lokkilokesh4388]

error-code-1292-incorrect-date-value-0000-00-00-for-date-column this error is coming bro while adding dates what should i do now??

[@ha6a6a]

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

[@mayanksharma-ez8tz]

Thanks Bro... ORACLE main milte hain..!! ;)

[@sreenivasguttula9347]

thanks a lot , could you please explain with multiple tables using group by clause

[@nkrawal6]

how to use group by without aggregate function in select list

[@ankurkumarupadhayay4304]

pls upload a video about HAVING clause

[@mohitdhiman5840]

very good :) very hep full

[@davidlewisn1017]

Hello, Hello,Great work you are doing in computer training. I am generating reports and i have challenges in using using sum and group by in my sql querries. Could you kindly offer some help i am stuck on these . Your help is much appreciated. David

[@baratamjitendra1733]

please tell link between group by & aggregate function

[@nicsonmartinez8252]

Amazing!! Thank You

[@anilkumarsahu939]

What happen when we type Select count(subject)

[@emmawtsnnfrlifeee4106]

Thank you so much

[@raghavgupta1157]

on which software you are fireing queries?

[@informativecontent4778]

MYSQL Workbench

[@mathsmeetbyprof.hitendrapa9359]

AWESOME :-)

[@mathimagery]

What if we use group by without count..

[@abhi13456]

+Ajay Bhattacharjee It will work and return distinct records

[@pokeTsareena]

Thanks bruh

[@enobongoguntola8632]

Thanks

[@numbgaming716]

thanks a lot..!!

[@sandipb8822]

thank u

[@kolibri5861]

u know

[@nklee1980]

bro...u talk too much which is not related to the title...just give answer directly to title...

[@PunjabiKush]

Waste of time! annoying audio

[@madhurbhatia89]

Oops!

[@JohnSmith-hn6kv]

Can you please talk slower, I keep on having to pause the video.