Fundamentals of MySQL
- 9.7
- Programming
- 8 Episodes
- 1 hr 16 minutes
- Framed By : Floyd Lover
EP 6 - MySQL Aggregate Functions
Learn how to use SQL's basic aggregation functions like COUNT, SUM, AVG, MAX, and MIN in this step-by-step tutorial!
Queries:
1) Get a count of all the rows: SELECT COUNT(*) FROM table
2) Get a SUM of a column in all the rows: SELECT SUM(column1) FROM table
3) Get the maxium number in a column: SELECT MAX(column1) FROM table
4) Get the minimum number in a column: SELECT MIN(column1) FROM table
5) You can also do arithmatic with these aggregate functions: SELECT MAX(column1)-MIN(column1) AS range FROM table
6) Or, like this: SELECT AVG(column1*column2) FROM table
Content Source : https://www.youtube.com/@becomingADS
Reviews
3There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don't look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn't anything embarrassing hidden in the middle of text.
There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don't look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn't anything embarrassing hidden in the middle of text.
There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don't look even slightly believable. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn't anything embarrassing hidden in the middle of text.