/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 vote384 views1 answer
Oracle to_number
SQL
1 vote431 views1 answer
How to put value in variable mysql
SQL
0 vote369 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
0 vote361 views1 answer
Mysql select all table that have field names
SQL
1 vote364 views3 answers
Getdate function in postgresql
SQL
0 vote805 views2 answers
Zsh: command not found: mysq
SQL
0 vote373 views1 answer
Oracle select partition
SQL
0 vote387 views1 answer
SQLServerException.makeFromDatabaseError
SQL
0 vote341 views1 answer
Mysql export data with a where clause
SQL
0 vote415 views1 answer
Oracle chain step succeeded
SQL