/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

1 vote289 views1 answer
Regular expression in sql server
SQL
1 vote275 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
36 votes345 views6 answers
Change column data type sql
SQL
1 vote286 views1 answer
Postgres cast as currency format
SQL
0 vote285 views1 answer
Mysql failed to login as root@localhost
SQL
7 votes280 views1 answer
Sql server convert string to date
SQL
0 vote315 views1 answer
Pgadmin save data greyed out
SQL
0 vote278 views1 answer
Liquibase update row
SQL
3 votes277 views2 answers
Plsql print
SQL
0 vote280 views1 answer
How to do a function to return row type from a table in pl/sql
SQL