/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 vote122 views1 answer
Top frequency in sql server
SQL
0 vote123 views1 answer
Pl/sql loop example
SQL
1 vote122 views4 answers
Fatal database postgres does not exist
SQL
8 votes122 views2 answers
Replace string value in sql
SQL
0 vote133 views1 answer
Databricks install odbc driver connect to sql server
SQL
1 vote140 views1 answer
Oracle compile schema
SQL
10 votes93 views2 answers
Sql where clause multiple values
SQL
0 vote119 views1 answer
Update top 100 sql
SQL
0 vote132 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
0 vote127 views1 answer
Sql tabelle erstellen
SQL