Select SUM(employeesalary) from tablename Explain MySQL Aggregate Functions. AVG : Returns the average value of the given argument.2. BITAND : Returns the result of bitwise AND3.
![Group_concat Sum Mysql Group_concat Sum Mysql](/uploads/1/2/5/5/125543527/763051886.png)
Mysql – groupconcat The GROUPCONCAT aggregation function returns a non-NULL set of fields within the group. For example, let us imagine that you have a table prize which consists of events and their respective prizes.
BIT OR : Returns the result of bitwise OR4. BIT XOR : Returns the result of bitwise XOR5. COUNT : Returns number of rows6. COUNT (DISTINCT): Returns the count of unique values.7. GROUPCONCAT : Returns concatenated string8.
MAX : Returns the maximum value9. MIN : Returns the minimum value10.
STD : Returns the standard deviation11. SUM : Returns the sum of a set of values12. VAR : Returns the variance.
![Group_concat Group_concat](/uploads/1/2/5/5/125543527/655797393.jpg)
I've got the following tables:users: mysql test SHOW CREATE TABLE usersG. 1. Row.Table: usersCreate Table: CREATE TABLE `users` (`id` int(10) unsigned NOT NULL AUTOINCREMENT,`name` varchar(20) DEFAULT NULL,`product` int(10) DEFAULT NULL,PRIMARY KEY (`id`)) ENGINE=InnoDB AUTOINCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb40900aici1 row in set (0.00 sec)groups: mysql test SHOW CREATE TABLE `groups`G. 1.
Row.Table: groupsCreate Table: CREATE TABLE groups (`id` int(10) unsigned NOT NULL AUTOINCREMENT,`userid` int(10) DEFAULT NULL,`name` varchar(20) DEFAULT NULL,`active` tinyint(1) NOT NULL DEFAULT '0',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTOINCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb40900aici1 row in set (0.01 sec)products: mysql test SHOW CREATE TABLE productsG. 1.