Aggregate Functions in SQL - COUNT, SUM, AVG, MAX, MIN | SQL Tutorial in Hindi 8

Поделиться
HTML-код
  • Опубликовано: 5 авг 2024
  • SQL Full Course Playlist 👇
    • SQL Tutorial In Hindi
    Like, Share & Subscribe Now :)
    ⭐ Subscribe for more SQL tutorials like this: bit.ly/3Fc7Gc6
    👉 customer csv file: bit.ly/3KLPb2P
    👉 payment csv file: bit.ly/41kIYjW
    📢 GitHub link (all files): bit.ly/3Y7SRPr 📢
    ➖➖➖➖➖➖➖➖➖➖➖➖➖
    Aggregate Functions Documentation:
    www.postgresql.org/docs/9.5/f...
    Timestamps:
    00:00 Intro
    00:14 Aggregate Functions
    01:12 Aggregate Functions Examples
    04:18 Aggregate Functions Documentation
    ➖➖➖➖➖➖➖➖➖➖➖➖➖
    Related Videos
    Introduction to SQL - What Is SQL + Database | SQL Tutorial In Hindi 1
    • What Is SQL ? | Databa...
    Data Types, Primary-Foreign Keys & Constraints in SQL | SQL Tutorial In Hindi 2
    • Data Types, Primary-Fo...
    Create Table In SQL & Create Database | SQL Tutorial In Hindi 3
    • Create Table In SQL & ...
    INSERT UPDATE, DELETE & ALTER Table in SQL With Example | SQL Tutorial in Hindi 4
    • INSERT UPDATE, DELETE ...
    SELECT Statement & WHERE Clause with Example | Operators in SQL | SQL Tutorial in Hindi 5
    • SELECT Statement & WHE...
    How To Import Excel File (CSV) to SQL | Import Data From File | SQL Tutorial in Hindi 6
    • How To Import Excel Fi...
    String Functions in SQL | Functions in SQL | SQL Tutorial in Hindi 7
    • String Functions in SQ...
    ➖➖➖➖➖➖➖➖➖➖➖➖➖
    Connect on other Social Media handles:
    Instagram: / rishabhnmishra
    LinkedIn: / rishabhnmishra
    Twitter: / rishabhnmishra
    ➖➖➖➖➖➖➖➖➖➖➖➖➖
    If this is the first ever video you're watching allow me to introduce myself, Hey I'm Rishabh Mishra and currently working as Senior Data Analyst at Bangalore. On this channel I like to guide and help my juniors and data science aspirants regarding Data Science jobs and useful tips for college students.
    Have a great day buddy!

Комментарии • 29

  • @atul_pratik
    @atul_pratik Год назад +15

    This channel so underrated man! Rishabh Bhai you are awesome, you might not even have the slightest of the idea how much value you provide to people/learners like us who are from a non-tech background. The way you make things lucid and limpid is worth the appreciation. Keep up the good work! 🙌❤‍🔥

    • @RishabhMishraOfficial
      @RishabhMishraOfficial  Год назад +2

      Wow.. this is really kind of you to write such a inspiring comment. Thanks a lot 👍

  • @Datazone12
    @Datazone12 3 месяца назад +4

    Want to add VERY IMP point regarding the count() function.... Using count(*) gives the total number of rows in a table, while count(column_name) counts only the rows where the specified column has a non-null value. If you use count(column_name), it may not accurately reflect the total number of rows because it ignores null values in that column. So, be careful when using count(column_name) as it might give a wrong count if there are null values in that column.

  • @Vampire44273
    @Vampire44273 Год назад +2

    Your teaching method is excellent 🙌🏻🔥

  • @KS0607
    @KS0607 8 месяцев назад +1

    u r a blessing bro

  • @chandarkumar2655
    @chandarkumar2655 Год назад +1

    Good information Bro
    keep it up

  • @arhaam_val
    @arhaam_val Месяц назад

    Thanks for the help !❤

  • @pankajSDG
    @pankajSDG 3 месяца назад +1

    Thank you guru🎉

  • @Vampire44273
    @Vampire44273 Год назад

    Excellent work sir👍🙌🏻 please make a video on Data analytics interview questions

  • @sgiione
    @sgiione 6 месяцев назад

    Thankyou bhaiya

  • @sudeep246
    @sudeep246 Год назад +1

    mast hai bhai

  • @haider3936
    @haider3936 4 месяца назад +1

    zabardast

  • @poojajaiswar5229
    @poojajaiswar5229 Год назад +2

    Hello sir a huge salute to you. Where everyone is charging big big amounts for a single course you are teaching us for free. Thank you so much 😊
    One request to you sir please make a playlist of python too how you did for SQL with the project. Thank you so much once again 🙏

  • @arshiyafarheen505
    @arshiyafarheen505 8 месяцев назад +1

    Simple and precise ✨ Thank you so much

  • @amankhan9550
    @amankhan9550 3 месяца назад +1

    Excellent teaching🎉❤

  • @vinaykumarmalvi614
    @vinaykumarmalvi614 Год назад +1

    Bhai power bi ki bhi video bana skte ho kya not for basics level..

  • @sakshamprime7128
    @sakshamprime7128 Месяц назад

    the data type chang is not working while changing into integer value, any reason and solution

  • @motivation4you585
    @motivation4you585 Год назад +1

    Hello sir,
    I am unable to create column of payment date
    Can u please provide the data type of payment date column

    • @RishabhMishraOfficial
      @RishabhMishraOfficial  Год назад

      Simple example to create table
      CREATE TABLE employees (
      employee_id serial PRIMARY KEY,
      first_name VARCHAR (255),
      last_name VARCHAR (355),
      birth_date DATE NOT NULL,
      hire_date DATE NOT NULL
      );

  • @pankajSDG
    @pankajSDG 3 месяца назад

    I want proper coaching.

  • @ashishchakraborty413
    @ashishchakraborty413 4 месяца назад

    Sum

  • @manojk2890
    @manojk2890 3 месяца назад

    itana acha nahi laga agar ye sab ham excel me kar sakte hai to sql ki kya jarurat

    • @RishabhMishraOfficial
      @RishabhMishraOfficial  3 месяца назад +1

      Aree bhai bhai bhai.. first video dekgo- sql introduction. Answer mil jayega ki yeh san excel mei kyu nhi kr sakte

    • @manojk2890
      @manojk2890 3 месяца назад

      @@RishabhMishraOfficial Bhaiya ji . aap ka reply acha laga..main koshish karunga..ki aap ka pahala video dekhu.. bad me dicide kru

    • @zaid9183
      @zaid9183 17 дней назад

      @@manojk2890 excel if for small data and sql is used for large data