/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

2 votes188 views2 answers
Create empty table from existing table
SQL
2 votes224 views3 answers
How to replace null values in sql
SQL
2 votes181 views2 answers
Change mysql password from command line
SQL
1 vote191 views1 answer
Retrieve meaning
SQL
-1 vote129 views1 answer
Mysql how to set update or create
SQL
4 votes182 views1 answer
Delete record mysql query
SQL
0 vote166 views2 answers
Postgresql create role
SQL
0 vote173 views1 answer
AddEntityFrameworkSqlite
SQL
3 votes182 views1 answer
Select count from table mysql
SQL
16 votes187 views2 answers
Sql exists
SQL