/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 vote100 views1 answer
Oracle character set
SQL
0 vote134 views1 answer
Restart sql server command line linux
SQL
0 vote142 views1 answer
To change the database owner in SQL server
SQL
0 vote173 views2 answers
Postgres isnull
SQL
0 vote144 views1 answer
Calculate age in sql
SQL
0 vote125 views1 answer
SQL division of an integer by another integer get float CAST
SQL
0 vote154 views1 answer
Sql alter table order by
SQL
0 vote104 views0 answer
SQL
0 vote248 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
0 vote146 views1 answer
Sql query for select from specific columns in a table
SQL