- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How can we use MySQL SUM() function to calculate the sum of only dissimilar values of the column?
For calculating the sum of only dissimilar values of the column we can use ‘DISTINCT’ keyword along with the name of the column. To understand SUM() function for dissimilar values, consider an ‘employee_tbl’ table, which is having the following records −
mysql> SELECT * FROM employee_tbl; +------+------+------------+--------------------+ | id | name | work_date | daily_typing_pages | +------+------+------------+--------------------+ | 1 | John | 2007-01-24 | 250 | | 2 | Ram | 2007-05-27 | 220 | | 3 | Jack | 2007-05-06 | 170 | | 3 | Jack | 2007-04-06 | 100 | | 4 | Jill | 2007-04-06 | 220 | | 5 | Zara | 2007-06-06 | 300 | | 5 | Zara | 2007-02-06 | 350 | +------+------+------------+--------------------+ 7 rows in set (0.00 sec)
Now, suppose based on the above table you want to calculate the total of all the dialy_typing_pages having dissimilar values, then you can do so by using the following command −
mysql> SELECT SUM(DISTINCT daily_typing_pages) -> FROM employee_tbl; +-------------------------+ | SUM(daily_typing_pages) | +-------------------------+ | 1390 | +-------------------------+ 1 row in set (0.00 sec)
The above result set shows that MySQL SUM() with a DISTINCT keyword, calculate the sum of only dissimilar record i.e. it adds the value ‘220’ for one time only.
- Related Articles
- How can we use MySQL SUM() function?
- How can we use MySQL SUM() function with HAVING clause?
- Can we use the result of a SUM() function in MySQL WHERE clause
- How MySQL SUM() function evaluates if the column having NULL values too?
- How can we use MySQL function STR_TO_DATE(Column, ‘%input_format’)?
- How can we use MySQL EXPORT_SET() function with column of a table?
- Python – Group and calculate the sum of column values of a Pandas DataFrame
- How can we get only unique values of a column in MySQL result set?
- How can we use MySQL POWER() function with the column’s data values?
- Sum the values in a column in MySQL?
- How can we use LPAD() or RPAD() functions with the values in the column of a MySQL table?
- MySQL SUM function to add decimal values
- How can we use INSERT() function to insert a new string into the value of a column of MySQL table?
- MySQL query to group by column and display the sum of similar values in another column
- How to select the sum of the column values with higher value in reach row with MySQL?

Advertisements