/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 votes226 views4 answers
Mysql decimal
SQL
0 vote221 views1 answer
Sql grant select only
SQL
0 vote234 views1 answer
Mysql random number between 1 and 100
SQL
5 votes257 views1 answer
Oracle get ddl
SQL
17 votes239 views4 answers
Sort by mysql
SQL
11 votes216 views2 answers
Sql rank
SQL
0 vote220 views2 answers
SQL FROM
SQL
0 vote220 views1 answer
Cara menampilkan user di mysql terminal
SQL
0 vote239 views1 answer
Change filed order in mysql
SQL
0 vote249 views1 answer
Mysql default tls v1.3 ciphersuites
SQL