SQL Advanced Aggregate Functions
SQL Advanced Aggregate Functions
An aggregate function performs a calculation on a set of values, and returns a single value. Except for COUNT(*) , aggregate functions ignore null values. Aggregate functions are often used with the GROUP BY clause of the SELECT statement.
Tutorial Outline:
0:00 Introduction
0:16 Open SSML
0:34 Run Employee table statement
0:48 Aggreagate Function (Count)
3:33 Adding age statement
4:46 Check the age function
5:43 Using HAVING
8:00 Conclusion
🗣 Connect with me on social
LinkedIn: https://tinyurl.com/yckpwwpz
Twitter: / carlhufftech
Facebook: / carlhufftech
TikTok: https://www.tiktok.com/@carlhufftech?...
Instagram: / carl.huff.tech
🙏 Request How To Tutorial Videos
Leave a comment to request.
🔔 Subscribe to my YouTube channel
https://tinyurl.com/yckuv78h
🎬 Want to watch again? Navigate back to my YouTube channel quickly
https://tinyurl.com/yckuv78h
