/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

5 votes197 views2 answers
Postgres update with if condition query
SQL
5 votes214 views1 answer
Oracle asynchronous query
SQL
0 vote223 views1 answer
Local pg_sql to heroku pg_sql
SQL
3 votes192 views1 answer
Mysql set field unique
SQL
0 vote207 views1 answer
Mysql regex exact match
SQL
2 votes342 views1 answer
How to create sql database
SQL
5 votes193 views1 answer
Oracle nls session
SQL
0 vote155 views0 answer
SQL
9 votes215 views4 answers
SQL Date Format
SQL
0 vote190 views1 answer
Mysql search like but first exact match
SQL