/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

5 votes152 views2 answers
Mysql create database charset utf8mb4
SQL
2 votes137 views1 answer
Where clause for child record apex
SQL
4 votes160 views2 answers
Postgresql float data type
SQL
0 vote131 views1 answer
Where date in datetime mysql
SQL
7 votes130 views4 answers
How to reset the identity column in sql server
SQL
0 vote144 views1 answer
Sql select sum group by id laravel join
SQL
0 vote135 views1 answer
Create table in dbms cmds
SQL
2 votes174 views1 answer
Get the mysql table columns data type mysql
SQL
0 vote132 views1 answer
Pl sql search saurce code
SQL
0 vote180 views1 answer
Alternative for LIMIT sql
SQL