/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

18 votes137 views4 answers
Uninstall mysql on ubuntu
SQL
0 vote145 views1 answer
Make parameters nullable in sql server
SQL
19 votes159 views6 answers
Create table sqlite
SQL
-1 vote144 views1 answer
MYSQL stored procedure select from
SQL
0 vote140 views1 answer
Get date ISO in psql
SQL
0 vote126 views1 answer
Insert data from stored procedure into table
SQL
0 vote141 views1 answer
Oracle table free space
SQL
1 vote124 views1 answer
Mysql select another database
SQL
4 votes129 views4 answers
What is primary key
SQL
0 vote149 views1 answer
Sql server create constraint
SQL