/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 vote218 views1 answer
Hierarchal database table
SQL
2 votes302 views1 answer
Oracle run_duration to number
SQL
0 vote206 views1 answer
Convert uniqueidentifier to varchar in sql
SQL
0 vote231 views2 answers
PostgreSQL having
SQL
0 vote211 views1 answer
Sql select all records from all tables where not empty
SQL
0 vote205 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
8 votes297 views1 answer
Insert a select statement into a table
SQL
18 votes202 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
SQL
0 vote851 views2 answers
Remove mysql workbench ubuntu
SQL
4 votes202 views2 answers
Dbms_scheduler stop job
SQL