Скачать или смотреть Basic Aggregate Functions in SQL (COUNT, SUM, AVG, MAX, and MIN)

‪@SaraswatiEdutech‬
Learn how to use SQL's basic aggregation functions like COUNT, SUM, AVG, MAX, and MIN in this step-by-step tutorial!
SQL Aggregation Tutorial:    • aggregate functions in sql  
Queries:
1) Get a count of all the rows: SELECT COUNT(*) FROM table
2) Get the SUM of a column in all the rows: SELECT SUM(column1) FROM table
3) Get the maximum 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 arithmetic with these aggregate functions: SELECT MAX(column1)-MIN(column1) AS range FROM table
6) Or, like this: SELECT AVG(column1*column2) FROM table
#SQL #AggregateFunctions #dataanalysis #sqltutorial #databasemanagement #techskills #SQLTips #mysql_workbench #mysql #mysqlcourse #DBMS#databasemanagementsystem #btechDBMS#DatabaseManagementSystems#DBMSforbtech#databasequeries