/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 vote228 views1 answer
Sql track modification
SQL
5 votes244 views2 answers
Oracle list columns
SQL
0 vote235 views1 answer
Jdbc sql connection string
SQL
0 vote227 views2 answers
How to update the multiple rows in sql
SQL
0 vote241 views3 answers
Osx stop mysql service
SQL
0 vote256 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
1 vote234 views1 answer
How to run parallel queries in sql server with entity framework
SQL
1 vote243 views1 answer
Login to database mysql terminal
SQL
0 vote239 views1 answer
Sql decode
SQL
1 vote226 views1 answer
Mysql view command
SQL