SQL Advanced Aggregate Functions

Published: 10 April 2022
on channel: Carl Huff

833

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

On this page of the site you can watch the video online SQL Advanced Aggregate Functions with a duration of hours minute second in good quality, which was uploaded by the user Carl Huff 10 April 2022, share the link with friends and acquaintances, this video has already been watched 833 times on youtube and it was liked by 4 viewers. Enjoy your viewing!

31,298,381

262K