/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 vote185 views2 answers
Tsql row number
SQL
0 vote175 views2 answers
Update information in a mysql column
SQL
0 vote218 views1 answer
Sparql if bound query
SQL
0 vote180 views1 answer
Postgre admin slow
SQL
-1 vote183 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
13 votes186 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
1 vote228 views1 answer
Postgresql if 0 then 1
SQL
14 votes195 views4 answers
Import database through command line
SQL
12 votes212 views1 answer
Create column sql server
SQL
0 vote148 views0 answer
SQL