Group By Clause in MySQL| Aggregate Function In Hindi | #8 | SQL GROUP BY
MySQL Group By | Aggregate Function In Hindi
MCA MSC-023 Block 2 Unit 1.4
About Video
1. Group by ka upyog kar ham ek se adhik row ki values ko kisi formula ke dwara calculation karte hain , yani ki aapko Sum karna ho ya aap average nikalana chate hain, ya minimum value find karna ho ya maximum value find karna ho , ya counting karna ho.
2. Group by hamesha aggregate function ke sath hi chalta hain
3. yadi aap bina aggregate function ke group by likhenge to vah keval data ko distinct hi kar payega
4. is video me pancho aggregate functon ke bare me bataya hain (count, sum, avg, min, max)
5. windows aggregate function ke sath group ki aavashyakta nahi hoti hain.
Read More
https://selfimagination.in/tips/mysql...
0:00:00, Introduction
0:05:09 GROUP BY
0:46:14 Group Without GROUP BY
1:47:14 GROUP BY With Column Name
4:36:16 GROUP BY Without Aggregate Function
5:46:07 Aggregate Function
5:54:12 COUNT Aggregate Function
6:26:19 SUM Aggregate Function
7:11:29 AVG Aggregate Function
8:10:21 Min/Max Aggregate Function
#learnsql #mysqltutorials #hindi