How to output only 1 if data same

Question

I try it, but didn't output like i want.

Example:

I have table like this :

+----+------+------+
| Id | Name | Total|
+----+------+------+
|  1 | Joni |   2  |
|  2 | Brad |   1  |
|  3 | Joni |   3  |
|  4 | Chuck|   1  |
|  5 | Brad |   3  |
|  6 | Brad |   5  |
+----+------+------+

And i want output like this :

+------+------+
| Name | Total|
+------+------+
| Joni |   5  |
| Brad |   9  |
| Chuck|   1  |
+------+------+
* Count total by Distinct name

Thank you.

Does this answer your question? [How does GROUP BY work?](https://stackoverflow.com/questions/7434657/how-does-group-by-work) — Boendal, Dec 22 '19 at 13:50

Hitesh Kumar · Accepted Answer · 2019-12-22T13:42:16.220

1

You can make your query like this for getting same result that you want -

SELECT SUM(Total) as total,Name from table_name group by Name;

edited Dec 22 '19 at 13:42

answered Dec 22 '19 at 13:28

Hitesh Kumar

383
2
6

I try GROUP BY `Name`. And it works thanks – Haruaki Dec 22 '19 at 13:52
If it's worked for you, than upvote the answer brother. – Hitesh Kumar Dec 22 '19 at 13:57

How to output only 1 if data same

1 Answers1