/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

1 vote195 views1 answer
Oracle update with sequence
SQL
0 vote218 views3 answers
Sql drop all tables
SQL
0 vote232 views5 answers
How to make trigger in phpmyadmin
SQL
0 vote257 views1 answer
Check user sql password from command line
SQL
5 votes224 views1 answer
Mysql count newlines in field
SQL
0 vote192 views1 answer
Sql how to display two atributes as one in sql
SQL
0 vote241 views1 answer
Plsql check how much space all databases are consuming
SQL
0 vote195 views1 answer
Oracle create table auto generated primary key
SQL
-1 vote249 views3 answers
MAKE TABLE FIT in oracle sql
SQL
1 vote189 views3 answers
Grant syntax in sql
SQL