/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 vote126 views1 answer
How to know if table in rigt or left in sql
SQL
2 votes114 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL
1 vote112 views2 answers
Sql left characters
SQL
8 votes143 views1 answer
Racle create auto increment column
SQL
0 vote109 views1 answer
Access refused mysql xampp server
SQL
4 votes111 views1 answer
Restart for pg_hba.conf file
SQL
0 vote110 views1 answer
Postgres float to int
SQL
18 votes112 views6 answers
Laravel form validation
SQL
0 vote148 views1 answer
Sql alternative to max statement
SQL
0 vote107 views1 answer
Mysql update privileges
SQL