/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 vote186 views1 answer
Select from 3 tables one is empty
SQL
0 vote181 views1 answer
Sql server inner join convert collation
SQL
0 vote191 views1 answer
Oracle last user logon
SQL
0 vote196 views1 answer
Mysql grouping functions
SQL
0 vote185 views1 answer
Différence entre deux dates sql oracle
SQL
0 vote215 views1 answer
How to find symmetric pairs in sql
SQL
0 vote207 views1 answer
Regex any word except sql
SQL
6 votes227 views6 answers
Rename column postgres
SQL
0 vote206 views1 answer
Hex string sql becomes int64
SQL
1 vote178 views2 answers
Sql select only first occurrence
SQL