/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 vote139 views1 answer
Login failed for user sql server
SQL
0 vote110 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
0 vote121 views1 answer
Postgresql replace html tags from string
SQL
3 votes118 views2 answers
Install mysql powershell
SQL
1 vote115 views4 answers
Mysqldump 1 table only
SQL
5 votes124 views1 answer
Oracle list functions
SQL
0 vote116 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
0 vote111 views1 answer
Price-colour
SQL
0 vote105 views1 answer
Sql developer export connections
SQL
2 votes117 views1 answer
Mariadb select multiple rows into one column
SQL