GROUP BY with Aggregate functions in SQL statement

[@alno1]

Thank you so so much! I finally understand 100% how to use group by clauses!

[@AhamedKabeer-wn1jb]

Thank you.. Well explained..

[@BronX005]

Seriously needed this video... thank you sir 🙏

[@timmytesla9655]

You have no idea how this has helped me. Thank you very much for this video.

[@soujanyakatuku1617]

excellent information and good explanation.......

[@Vantamanta]

Really good video with Good examples and nice explanation.

[@osoriomatucurane9511]

Awesome tutorial, concise and crystaal clear!

[@SAK-y6j]

Excellent

[@MrBauer73]

Very helpful :) thank you

[@supreranap9831]

Nice explanation tq

[@rave.201]

Bless u dude, finally can do the "invalid select list" issue :)

[@scottarena6808]

Excellent video. I am currently studying, on my own to become a DBA--this has been very helpful. Thank you for the video!

[@jorgepadron2426]

Excellent!

[@amralkhatib5031]

Thanks man i have seen about 10 videos but your video is the best

[@chitradevaki4966]

Thanks a lot very useful to write queries..very nicely explained covering all the scenarios

[@Daniel.E_Rides]

Great tutorial! Thanks

[@Hanna-bf3ug]

can you upload more video's please. you are one of these people who knows how to explain. Thanks so much I watched more than 10 video's trying to understand group by and finally i found you. thanks more please

[@SQLwithManoj]

Thanks so much Hanna... Could you plz tell me the topics that you like I should cover?

[@Hanna-bf3ug]

@@SQLwithManoj Thanks for the quick replay Manoj. Topics like store procedures, functions, subqueries, joins all the good stuff 🙂. Thanks again

[@supreranap9831]

Good

[@dogmahacker8278]

SOOOOOOOOOOOOOOOOO much better than my teacher!

[@majidshahani]

The way you explain is really great. Thanks Manoj sahib.

[@JohnJamalSingh]

Thanks so much Manoj, really its useful....

[@maf7764]

thank u so much

[@techtricks625]

This is really helpful for me ☺️ Thank you so much 😊

[@pinakim11]

Thanks Manoj,nice video. You explained nicely.

[@bingxiao1008]

It is really helpful. The explanation is concise and easy to understand. Thank you so much!

[@kspkumar7507]

THANK YOU SO MUCH

[@harishbabu6450]

Very nice Manoj, clear explanation !

[@divyakakkirala6088]

Thnq so much manoj, finally I understand how to write queries in SQL , one suggestion is , when am watching videos thorough mobile, there is no mobile compatibility for videos, mean to say SQL window not clarity can you check this.

THANK YOU!! This guide was super informative!

[@somnathgiri356]

After so many searches it's seems I clicked on the correct video.

[@anilkumaryadav106]

helpful,good job

[@ASHOKKUMAR-fj6ms]

Its excellent class , thank you sooooooooooooooo much manoj . your rocking man ,your explanation are simple super.

[@princenishad1]

this video help me a lot thank you so much sir

[@mohammedalshami3937]

Nice Explanation

[@sravanireddy2042]

nice explaination and thanks u so much mr.manoj

[@omojowoleke7130]

Tank u for a great work.

[@DybFrostDocuments]

Super video - thanks!

[@PrasantKumarV76]

You made it very easy and clear to practice. I did lot of experiments with the help of this. Appreciate your effort. Besides, I'm unable to find Joins video done by you. Can you provide the link or create video with some complex examples of various joins? Thanks!

[@RiteshKumar-qr7pq]

I watched lot of video on Group By clause but finally i got to understand what exactly it is thank u sir please make a video on Having clause in sql

[@SQLwithManoj]

HAVING clause video... kzbin.info/www/bejne/bqGnZKueaLKfhMk

[@harshadas3942]

Thanks a lot. This is really helpful. great explanation!!!!

[@umairzafar2067]

Great job...

[@crazytalkmeet5222]

thanks for your explanation. its really helpfull

[@gulzarsingh3681]

How to select other columns without aggregate. eg: select col1, col2, col3, col4, col5 from tab1 where col3=xval group by col5 . In Postgres

[@ManojPandeyManub22]

GROUP BY clause does not allow you to have columns that are not part of the GROUP-BY clause. Try using ROW_NUMBER() with Aggregate functions, link: sqlwithmanoj.com/2010/08/10/using-over-and-partion-by-clauses-with-aggregate-functions-in-sql-server/

[@paragawaken]

Very helpful.

[@oelh3426]

Thank you a lot , pro explanation

[@pinkilihitkar8093]

VERY USEFUL...BUT VOICE WERE LOW IN WHOLE VIDEO

[@althafmohammed5285]

Thanx manoj

[@johnmwenda353]

thanks... awesome explanation

[@broderick123456789]

Explained this beautifully.... I must add though even in your example, the glass ceiling was present. In every department Males had a higher salary than females lol

[@tusharjadhav4625]

Thanks a lot sir, video is very helpful

[@kessangla7864]

thank you sir

[@shounakrendalkar2732]

Really helpful!!!!!!!!!

[@amargorsipati9514]

Excellent bro

[@satishkumargarepalli3692]

soooo good do you have any videos related to store procedures, user defined functions,triggers??? please provide me the urls only t-sql i am asking

[@rajat_bisht_vlogs]

Sir how can we use Group by , count and join together?

[@SQLwithManoj]

Here is an example: SELECT D.DeptName, COUNT(E.EmployeeID) FROM Department D JOIN Employee E on E.DeptID = D.DeptID GROUP BY D.DeptName

[@SQLwithManoj]

If you need with WHERE & HAVING clause as well... check here: Here is an example: SELECT D.DeptName, COUNT(E.EmployeeID) FROM Department D JOIN Employee E on E.DeptID = D.DeptID WHERE E.Gender = 'Male' GROUP BY D.DeptName HAVING COUNT(E.EmployeeID) > 10

[@stephenr.kutuahn8763]

great,thanks

[@davidlewisn1017]

Hello,Great work, could you offer some help i am stuck on using sum and group by- your help is much appreciated.David

[@supreranap9831]

Hi Manoj please explain joins

[@sudeshhinge5391]

Thank You Sir !! Thanks a lot...............

[@mahdifardi6822]

so useful :))

[@78057530]

Awesome Bro !

[@althafmohammed5285]

I got confident aftr seeng dz

[@achulu87]

Nice bro 👍

[@kajoldave8122]

Write a query to list down employee details such as EMP_ID, FIRST_NAME, LAST_NAME, ROLE, DEPARTMENT, and EMP_RATING grouped by dept. Also include the respective employee rating along with the max emp rating for the department. how to do this? please helppppp

[@yogeswarannatarajan7315]

Thank you

[@oblivious36]

Excellent, Cheers

[@naresh90sharma]

Hi sir good evening, sir I'm using the query in Excel data connection , I don't have permission for data base one mstp , Sir my question is how to filter group sum & where condition like type = e and type = I type = as,

[@Curious_Stranger]

Each GROUP BY expression must contain at least one column that is not an outer reference.

[@kohli2419]

I want to add colum to a table while using the group by clause without sorting the data ,I don't need the col in group by but I need that column without grouping , I have already used the group by by another column

[@Jeremy-mr2qi]

papa bless

[@maryamaa556]

Thank you!!

[@jericunabia3584]

How about i want to see the average only the engineering?

[@tafiyer]

When you do count *, isnt it counting all vs number of employees ?

[@SQLwithManoj]

COUNT(*) means counting all rows, irrespective of what data it is, can be duplicate also.

[@daniwalker1996]

in your video the record is repeating more than one time is there any way to fix it ?

[@sumaiyasumi2610]

why u put order by after group by clause, If we dont use order by what will be difference, I didnt get it . sorry.

[@ManojPandeyManub22]

The ORDER BY clause, after GROUP BY clause is added to sort the record set by Departments & Gender.

[@stafaninadar964]

Can u combine count with average

[@ManojPandeyManub22]

yes, you can , please check at 11:48 time

[@stafaninadar964]

@@ManojPandeyManub22 I need to apply average with count value

[@ManojPandeyManub22]

can you please explain what you are trying to do? Like input and expected output, or query?

[@mdkhrafi]

Can we use 1.Having (condition) AND (condition) 2.Having (condition) OR (condition)

[@SQLwithManoj]

Yes, you can have AND & OR condition with HAVING clause, so that you can filter on aggregated data. If you want to filter on grouping columns then use WHERE cause.

[@mdkhrafi]

@@SQLwithManoj Thanks, yeah as far as I knew that we can use OR with WHERE also but can't use AND. Thanks again

[@SQLwithManoj]

you can use AND with WHERE clause also !!!

[@mdkhrafi]

Yes, I actually meant 2 rows at a time.

[@SQLwithManoj]

No, you can't use HAVING clause 2 times in a single query. But, if you have any such requirement then it could be done the other way. Let me know if you need some help?

[@jericunabia3584]

How about i want the average only in engineering.??? display only the average in engineering???

[@christiancampos8806]

help me answer my script : SELECT COUNT(Make, Model, ProcessorType) as "Number Available" FROM CR_computer;

[@SQLwithManoj]

you just need to have your query like this: SELECT COUNT(*) as "Number Available" FROM CR_computer;

[@bbibek1]

SIR CAN U EXPLAIN GROUP BY WITH ROLL UP AND CUBE..

[@SQLwithManoj]

sure, please stay tuned... will post shortly !!!

[@subratamitra6668]

Plz say in hindi

[@mrsmariam7952]

Deutsche?

[@kessangla7864]

thank you sir

[@karthickrk8918]

thank you sir