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

[@nileshrajput5648]

explanation level 💯 ☺️👌

[@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

[@palakmahajan9999]

Very nice explain 🤗👌

[@CodeEra2020]

Thank you so much

[@sss_0007]

pls ek detailed video "group by" ke upar🙏

[@CodeEra2020]

Sure I will make it very soon

[@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

[@suhanapatal87]

Good 👍

[@CodeEra2020]

Thank you so much

[@jyotikothari499]

Nice explaination...

[@CodeEra2020]

Thank you.

[@sangeethas2896]

Kindly make an second video for other functions.

[@CodeEra2020]

sure,keep watching

[@suhanapatal87]

Nice

[@CodeEra2020]

Thank you so much

[@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

[@swatipandey7585]

mam could you please share notes?