/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 vote156 views1 answer
Dump only data
SQL
4 votes148 views1 answer
Id primary key auto generated
SQL
2 votes233 views2 answers
Set value to null sql
SQL
1 vote154 views1 answer
Sql group by error
SQL
0 vote153 views1 answer
Drop tables from local database postgres pgadmin
SQL
0 vote184 views1 answer
Database db connection string format
SQL
1 vote152 views1 answer
Delete row mssql
SQL
0 vote143 views1 answer
Oracle list index on table
SQL
1 vote149 views1 answer
Oracle sql assign unique number to each grouping
SQL
0 vote155 views1 answer
Mysql bash execute sql file
SQL