/SQL/Mysql count multiple columns in one query

Mysql count multiple columns in one query

mysql count multiple columns in one query:
 SELECT 
        count(*)             as count_rows,
        count(col1)          as count_1,
        count(col2)          as count_2,
        count(distinct col1) as count_distinct_1,
        count(distinct col2) as count_distinct_2,
        count(distinct col1, col2) as count_distinct_1_2
    FROM `table` ;

Similar codes

0 vote123 views1 answer
What is between keyword used for
SQL
6 votes121 views2 answers
Mysql check auto increment value
SQL
1 vote122 views1 answer
Mysql view curren querys
SQL
4 votes131 views3 answers
Drop Table Oracle
SQL
0 vote128 views2 answers
Mysql missin expression near on
SQL
0 vote101 views1 answer
Possgress drop if exists view
SQL
0 vote246 views1 answer
Sql change a colum to unique
SQL
0 vote133 views1 answer
Mql5 datetime get hour
SQL
1 vote116 views1 answer
Mysql select update same table
SQL
0 vote124 views1 answer
Sparql list all graphs
SQL