/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

3 votes303 views2 answers
Synonym oracle
SQL
1 vote258 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote257 views1 answer
Mysql find missing values
SQL
5 votes298 views6 answers
In operator sql
SQL
0 vote256 views1 answer
Kotlin sqlite delete row
SQL
0 vote258 views1 answer
Power query case when
SQL
0 vote259 views1 answer
Alter table name including schema
SQL
1 vote277 views1 answer
Where to locate set password for mysql
SQL
0 vote285 views1 answer
How to update date value in sql
SQL
-1 vote266 views1 answer
Window functions in sql
SQL