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!
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! 🙌❤🔥
Wow.. this is really kind of you to write such a inspiring comment. Thanks a lot 👍
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.
Your teaching method is excellent 🙌🏻🔥
u r a blessing bro
Good information Bro
keep it up
Thanks for the help !❤
Thank you guru🎉
Excellent work sir👍🙌🏻 please make a video on Data analytics interview questions
Thankyou bhaiya
mast hai bhai
zabardast
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 🙏
Glad it was helpful n you liked it 👍
Yes will start a python series soon ✅️
Eagerly waiting for this sir😊
Simple and precise ✨ Thank you so much
Glad it was helpful! ✅️
Excellent teaching🎉❤
Glad you liked ✅️
Bhai power bi ki bhi video bana skte ho kya not for basics level..
the data type chang is not working while changing into integer value, any reason and solution
Hello sir,
I am unable to create column of payment date
Can u please provide the data type of payment date column
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
);
I want proper coaching.
Sum
itana acha nahi laga agar ye sab ham excel me kar sakte hai to sql ki kya jarurat
Aree bhai bhai bhai.. first video dekgo- sql introduction. Answer mil jayega ki yeh san excel mei kyu nhi kr sakte
@@RishabhMishraOfficial Bhaiya ji . aap ka reply acha laga..main koshish karunga..ki aap ka pahala video dekhu.. bad me dicide kru
@@manojk2890 excel if for small data and sql is used for large data