/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 vote254 views1 answer
Pgadmin check database
SQL
0 vote211 views1 answer
Select insert new table sql server
SQL
0 vote210 views1 answer
Drop domain postgresql
SQL
1 vote213 views3 answers
Mysql disable foreign keys check
SQL
1 vote249 views1 answer
Mysql view curren querys
SQL
0 vote237 views1 answer
T sql dynamic top n query
SQL
10 votes205 views3 answers
Sql limit results
SQL
8 votes218 views1 answer
Oracle all_source package body
SQL
12 votes241 views4 answers
How to check mysql version ubuntu
SQL
0 vote231 views1 answer
Postgres populate table from another table
SQL