Aggregate Function in MySQL | Sum | Avg | Max | Min | Count | In Hindi

Aggregate Function in MySQL | Sum | Avg | Max | Min | Count | In Hindi | Tutorial#14
in this playlist, I am going to start Structured Query Language (SQL). SQL is one of the best database software which is broadly used. It is mainly the syllabus part of 11/12/BCA/BTech student and I have designed this in such a way that it is specially designed for 11/12/BCA/BTech student. In this video, I have explained all important Aggregate Function in SQL.
Telegram Channel: t.me/codeitupl...
Facebook Group: / 21673. .
Instagram: t.me/codeitupyt
Facebook Group: www.facebook.c...
Facebook Page: / codeitup-104310264625489
Website: codeitup.in
Join this channel to get access to perks:
/ @codeitup
Link to Previous Video: • Date & Time Functions ...
Link to next video: • MySQL Joins | Equi Joi...
Tags Used:
sql aggregate functions sum
sql aggregate function avg
sql aggregate function count
sql aggregate function min max
sql subqueries
aggregate functions sql
aggregate functions in dbms
aggregate functions mysql
aggregate functions in oracle
aggregate functions in relational algebra
aggregate functions in sql server
aggregate functions and grouping
aggregate functions in mysql
aggregate functions in sql in hindi
aggregate functions definition
aggregate functions dbms
aggregate function in mysql
mysql tutorial
sql tutorial
mysql class 12
class 12 sql
class 12 mysql
class 12 python
python class 12
sql class 12
mysql class 12
sql
mysql
mysql functions
introduction to mysql
class xii mysql tutorial hindi
#codeitup
#sql
#cbse
@CBSE
@CBSE INDIA
@Unacademy CBSE Science 11 & 12
@CBSE Udaan XI
@Ncert Solutions CBSE ncerthelp.com ​

[@anjan4154]

You're a gem of a Teacher. Beautiful Smile, Beautiful Channel. Thanks a Million Anand sir.

[@codeitup]

Thanks & most welcome😊

[@awaisasif1500]

Great explanation without practical,delivering core concepts Masha Allah

[@codeitup]

Thanks dear, keep learning😊

[@tenzindorjee7689]

Thank you souch sir mysql journey is awesome with you 👍🏻🙏🙏 love ❤️ from Tibet

[@codeitup]

Always welcome😊

[@Rahulsingh12870]

Explanation is out of words thanks Anand sir

[@codeitup]

Thanks & most welcome Shakti!

[@dhaneshjain3536]

According to term 2 syllabus
This is my last SQL lecture
✨Thank you Anand sir ✨

[@codeitup]

Most welcome Dhanesh!

[@AsthaYadav09]

Plzz tell me term 2 syllabus.i am confused.

[@dhaneshjain3536]

@@AsthaYadav09 watch sir new videos

[@dhaneshjain3536]

@@AsthaYadav09 SQL and computer networks

[@sauravkasana8254]

Finally today I finished all my SQL . Thanks a lot sir. Waiting for your more videos on my SQL

[@codeitup]

Keep watching !

[@karankumawat8282]

paper ka ek bhi ma aapka vedio dhak kar ja rhu sir or mera pura quick revision ho rha h thanku so so so much sir
ma aapka vedio ko dhak kar class ma topper ban gya hu again thanks

[@codeitup]

That's great Karan😊👍

[@indiancitizen2787]

Sir i thank you from the bottom of my heart.........Such an amazing content......Helped me a lot in term 2 exams.......Great explaination......

[@codeitup]

Thanks & most welcome dear😊
God bless you!

[@Nic.hack12]

Thank you so much sir you're explanations are on point and very clear..this makes me confident about my topics and feel me proud. Thank you so much sir for your efforts...thanks a lot

[@codeitup]

Most welcome Nikita, keep learning.. 🙂

[@gaziogamer]

Apkee 100k hone chahiye, badiya padate ho quality content

[@codeitup]

Thanks a ton😊

[@mohammadamaanullah4498]

Thank you sir for the crystal clear explanation, it helps in tomorrow's pre-board exam.

[@codeitup]

Happy to help you🙂

[@Shreya-u5h]

Sir 2023-24,ke bachcho ke exam ki taiyari ke liye bhi video upload kijiye..Or jo apne MCQ ka video upload upload Kiya. Hai kya ve sab video 2023-24ke board exam ke liye thik hai ya nhi kyoki essal ke questions pichhal saale ke Questions se jyada tough hai

[@itzpkg]

Kasam se sir ...
Sach mza aa gya ...
Soch rha ki "Apun ko to sb aata hai bidu" :- (Rajpal Yadav dialogue)
But sir at last ... Revison of Practice mai lag kr jate hai ...vhi nhi chahiye

[@pubgmastergaming6454]

Sir sorry for this but aggregate function me where clause ka use nhi hota having clause ka hota h
Avg wale questions ki query
Select * from emp having salary = select max(salary) from emp;

[@vivekkumar3881]

Select * from emp having salary = (select max(salary) from emp);

[@AbhishekPandey-gm4wj]

Bhai agr waha pe grp by use krte h tb shayad having ka use hota nhi to where clause se hee km chl jata h

[@pubgmastergaming6454]

@@AbhishekPandey-gm4wj hm may be esa hota h Becoz isme confusion h bhaut

[@Maya-xx8jy]

Thanks sir es ke sir important questions answere bhi kra dijiye jo exam me a skte hai 🙏

[@codeitup]

Sure

[@harithar6944]

Thankss a lot sir love youu!!🙂😘😘😘👍

[@codeitup]

Most welcome Haritha!

[@tabishreyan1622]

You make all concept so easy

[@codeitup]

Glad to help you😊

[@itzpkg]

The way he teach us ...
That is very good ..and if anyone not ware about topic also ..if he will concentrate on wording ...he will alse have s me knowledge from Anand's sir Lectures only

[@alokitwilson9296]

50th like from my side❤

[@codeitup]

Thanks 😊

[@talatzeba1350]

Thanks a lot sir 😊😊
you helped me a lot ❤️❤️

[@codeitup]

Glad to help you😊

[@sharafatkhan0677]

🙄🙄

[@arteast4282]

Sir agar sum() function me apan character value daal de Jese name wala column, to wo add kese karega

[@rishabhd3612]

Sum integer pe lgta h

[@arteast4282]

@@rishabhd3612 arigato

[@umeshpandey9910]

gREt CONCEPTS BY GREAT TECHER

[@codeitup]

Thanks a million Umesh 😊

[@gaauuuriiii]

Thank you so much sir ❤️ You are really a good teacher

[@codeitup]

Thanks & most welcome Gauri!

[@smitadawn1240]

Sir, chapter 11 to 15 of sumita arora class 12th is all covered in ur sql playlist?

[@codeitup]

No, will upload these videos soon. SQL playlist contains only SQL.

[@itzpkg]

@@codeitup then sir ...
Can you make playlist regarding Lectures you uploaded on behalf of Sumita arora separately which will helpful for us ...
To find your videos ...in exam.time which will helpful to save our time ..and get better content from you...

[@snehalchanda1397]

u are amazing sir thank you so much

[@codeitup]

Thanks & most welcome Snehal!

[@snehalchanda1397]

@@codeitup Anand sir can u explain the group by , order by and having clause 🙏🙏

[@rumi797]

thanks sir. btw, ascending, descending, group by, order by, wo sab kisme aata hai

[@codeitup]

Under select command

[@Shreya-u5h]

Sir please hamari help kijiye ham totally aap pe depend 😢hai .

[@allyourtype5481]

Sir we can execute it by select * from epm where salary=max(salary);

[@codeitup]

No

[@student5715]

Sir DBMS kra dijiye

[@rakeshgitm]

Sir, day(2021-01-29); and dayofmonth(2021-01-29); in dono me he null show kar raha hai. What can I do for this?

[@shrifashionworld7738]

sir aisa bhi toh ho sakta haina :- select * from table where salary = max(salary); ? from this position of the video :- 12:32 ?

[@RishabSahu.]

11:05 is the important one

[@itzpkg]

Thx a lot sir

[@codeitup]

Most welcome !

[@xenon1787]

Here for term 2

[@badalkumar-ck1hj]

very good class sir

[@codeitup]

Thanks Badal!

[@khushik.357]

Thank you sir

[@codeitup]

Most welcome!

[@nopgamer388]

Thanks you very much

[@codeitup]

Most welcome!

[@Factsunite]

Everything is good but voice quality Very bad 😞

[@codeitup]

Voice quality is quite good, you have some problem with your device.

[@technicalkick3886]

always best.!!!

[@codeitup]

Thanks😊

[@Remixbyadityaa]

Sir aggregate function kis kis system par work krta hai?

[@shreshthtiwari7580]

Sir... In aggregate functios, in the sum()function,where the condition is applied "between".....is it take 1st and last value in the between command???????????

[@codeitup]

Yes it takes both values.

[@__gamerz9625]

Sir ye notes kha milenge

[@inspiringu460]

Sir should join be in term 2 sql Or not for computer science student, plzzz answer anyone

[@codeitup]

For any query please mail to [e-mail]!

[@mahak162]

Sir is this sql Playlist is enough for class 12 term 2 ip ?

[@codeitup]

Yes

[@faizanwani006]

Are easy lg rha hai😅

[@codeitup]

Yes, whole SQL is easy Abhishek !

[@itzpkg]

Sir hai ..to easy hai..
Let's start an campaign #let's make code easy with #codeitup

[@gulamheader903]

#Pls tell in this program how to counter the last else statement to execute
# Ignore the indentations
import pickle
with open('bin1','wb+') as f:
rec=[]
while True:
roll = int(input("Enter roll number:"))
name = input("Enter Name") rec.append([roll,name]) c= input('Want to enter more data?(Y/N)')
if c.lower() == 'n': break
pickle.dump(rec,f)
with open('bin1','rb') as f: data= pickle.load(f) print(data)
sk = int(input("Enter the roll number to search name:")) with open('bin1','rb+') as f: rrec=pickle.load(f)
for i in rrec:
if i[0]==sk:
print(i[1])
else:
print('Details not present')

[@codeitup]

Make the last else statement the part of loop, not the part of if.

[@gulamheader903]

@@codeitup That only i am asking that where shall i indent the else , with for or with if cz both are creating sm problems

[@codeitup]

@@gulamheader903 With for..

[@gulamheader903]

@@codeitup then it wiĺl always execute.... how to counter that

[@codeitup]

Try this code:
import pickle
with open('bin1','wb+') as f:
rec=[]
while True:
roll = int(input("Enter roll number:"))
name = input("Enter Name") rec.append([roll,name]) c= input('Want to enter more data?(Y/N)')
if c.lower() == 'n': break
pickle.dump(rec,f)
with open('bin1','rb') as f: data= pickle.load(f) print(data)
sk = int(input("Enter the roll number to search name:")) with open('bin1','rb+') as f: rrec=pickle.load(f)
for i in rrec:
if i[0]==sk:
print(i[1])
break
else:
print('Details not present')

[@khushikhushi7754]

Write a command to display distinct jobs where number of employees are less than 3. please help?

[@rishabhd3612]

Select Distinct (jobs) from table having count(employee)>3;

[@TOXIC-ry2ml]

Op sir

[@tabishreyan1622]

Hello sir

[@codeitup]

Hi

[@sheikhmuktadir260]

Thank you sir

[@codeitup]

Most welcome Muktadir!

[@faizalkhalifa9187]

Thanks sir

[@codeitup]

Always welcome Faizal!