SELECT ,DISTINCT and COUNT data from distincted value SQL

Question

How to distinct value,and count data from distincted values base on this data

   NAME |                  NAME | TOTAL
    A   |                   A   |   4
    A   |                   B   |   2
    A   |     INTO THIS
    A   |
    B   |
    B   |

i already tried this query

SELECT DISTINCT(name) ,COUNT(DISTINCT(NAME)) FROM tbl_a

but it shows only,even i used group by,and order by...

NAME |  TOTAL
 A   |    4

You forgot to give us the query you tried. – JMichelB Nov 09 '17 at 23:42 — JMichelB, Nov 09 '17 at 23:42

score 2 · Accepted Answer · answered Nov 09 '17 at 23:43

2

You can do it like this:

select NAME, COUNT(NAME)  
from tbl_a
group by NAME;

answered Nov 09 '17 at 23:43

Booleanly Truthy

150
6

this works ! thanks ! – Bakti Wijaya Nov 09 '17 at 23:45
i had to wait 9 more minutes to mark the answer – Bakti Wijaya Nov 09 '17 at 23:46
Ok, cool, whenever you can. Thanks :) – Booleanly Truthy Nov 09 '17 at 23:47

score 0 · Answer 2 · answered Nov 09 '17 at 23:42

0

SELECT COUNT(DISTINCT name_column) AS some_alias FROM table_name

answered Nov 09 '17 at 23:42

Paul Strupeikis

275
3
11

i tried this one,but only distinct the NAME column,not showing total of distincted values,but thanks – Bakti Wijaya Nov 09 '17 at 23:46

SELECT ,DISTINCT and COUNT data from distincted value SQL

2 Answers2