Count number of unique value for multiples column Mysql

Question

I Have a table like this and I would like to get the number of distinct value for these 3 column (string_2 string_2 and string_3)

I know how to do a distinct and count in mysql, but in this case, I dont know how to count different distinct value for multiple column

The input I would like to have is

Jared Dunham · Accepted Answer · 2019-02-22 19:12:48Z

2

You need to use a combination of count and distinct:

SELECT 
    count(distinct string_1) AS string_1, 
    count(distinct string_2) AS string_2, 
    count(distinct string_3) AS string_3 
FROM table_name

answered Feb 22, 2019 at 19:12

Jared Dunham

1,5273 gold badges19 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Count number of unique value for multiples column Mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related