Aggregate Functions In SQL | COUNT, SUM, AVG, MIN, MAX | IFNULL( )

In this video we will discuss different aggregate functions in SQL with some practical examples..
1) COUNT() - 02:08
2) SUM() - 05:55
3) AVG() - 10:00
4) MIN() - 12:20
5) MAX() - 14:30
⭐Difference Between DELETE, DROP and TRUNCATE
• Difference Between DEL...
⭐Part 1:Top 9 SQL queries for interview -
• Top 9 SQL queries for ...
⭐Part 2:Top 9 SQL queries for interview -
• PART 2 : Top 9 SQL que...
⭐Types of Joins in SQL-
• SQL Joins & Its Types ...
⭐Create MySQL Database and Table -
• How to Create Database...
TCS NQT Sample Paper:
👉drive.google.c....
TCS NQT Sample Paper solutions:
• TCS NQT 2021 Complete ...
TCS NQT 2021 Complete Registration Process | Exam Pattern
👉 • TCS NQT 2021 Complete ...
✔Difference between oop and pop :
👉 • Difference between OOP...
💥Access Modifier in Java-Public,Protected,Private and Default
👉 • Access Modifier in Jav...
💥Constructor in Java
👉 • Constructor In Java |T...
💥Part 3 of 3 :Database Connectivity
👉 • How to Fetch Data from...
💥Part 2 of 3 :Database Connectivity
👉 • How To Insert Data In ...
💥Part 1 of 3 :Database Connectivity
👉 • Database Connectivity ...
⭐Encapsulation in java-
• Java tutorial|#Encapsu...
⭐DBMS vs RDMS
• DBMS vs RDBMS | What i...
⭐Keys in DBMS
• Types of Keys in DBMS ...
⭐Normalization in DBMS-
• Normalization and its ...
⭐class and object in java-
• What is Class and Obje...
⭐Types of key in DBMS-
• Types of Keys in DBMS ...
⭐how to install java-
• How to Install JAVA JD...
⭐Introduction of java:-
• Introduction to Java i...
⭐Features of java:-
• Features of java Part 2
⭐JVM JRE JDK:-
• JDK JRE JVM in Java Pa...
⭐JVM architecture-
• JVM architecture in Java
#mysql #sql #aggregateFunction #database #COUNT #SUM #AVG #MIN #MAX #SQLTutorial

[@nileshrajput5648]

explanation level 💯 ☺️👌

[@CodeEra2020]

Thank you so much

[@palakmahajan9999]

Very nice explain 🤗👌

[@CodeEra2020]

Thank you so much

[@suhanapatal87]

Good 👍

[@CodeEra2020]

Thank you so much

[@amanrathore9775]

hi , very nice explanation, there is one request from you please make second part on this aggregate fn also please include interview questions for better understanding. :)

[@CodeEra2020]

Sure I will. Thank you for watching

[@jyotikothari499]

Nice explaination...

[@CodeEra2020]

Thank you.

[@jangidmihonortech3442]

Thank you mam for making videos on sql. Mam please i request you to please make more videos on the sql.

[@jangidmihonortech3442]

yes

[@CodeEra2020]

Thank you so much.. Sure we will upload more on sql

[@raginikumari2290]

What if, in name column more than one name starts with A?? The table you have shown there is only one name starts with A and hence It results Ankush Rajput, as the logic given by you is as per alphabet sequence it will be picked but for ex there in another Name ( Anand Singh) in the Name column then what will be the result?? Please clear this doubt.
It is from Min() with single column.

[@CodeEra2020]

Result will be 'Anand Singh' because as I said it will work alphabetically .
first two letters are same that is 'An' in both the name but in Ankush third letter is K while in Anand third letter is 'A' so A comes before K so output will be Anand singh.
This works exactly like a dictionary
Thank you for watching..

[@raginikumari2290]

@@CodeEra2020 understood, thank you. Thanks for your efforts.

[@CodeEra2020]

@@raginikumari2290 You are welcome

[@suhanapatal87]

Nice

[@CodeEra2020]

Thank you so much

[@sss_0007]

pls ek detailed video "group by" ke upar🙏

[@CodeEra2020]

Sure I will make it very soon

[@sangeethas2896]

Kindly make an second video for other functions.

[@CodeEra2020]

sure,keep watching

[@swatipandey7585]

mam could you please share notes?