/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 vote352 views1 answer
Sql show all users
SQL
5 votes375 views1 answer
Sql integer to serial
SQL
4 votes328 views1 answer
Mysql biginteger size
SQL
2 votes348 views1 answer
How to check grants on a package in oracle
SQL
1 vote369 views1 answer
Oracle get current schema
SQL
1 vote364 views1 answer
Postgresql escape single quote
SQL
0 vote346 views1 answer
Add unique constraint sql server multiple columns
SQL
0 vote347 views1 answer
Update view sql
SQL
0 vote330 views1 answer
Sub blocks in sql
SQL
0 vote349 views1 answer
Python connect microsoft sql server
SQL