/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 votes333 views2 answers
Oracle to_timestamp
SQL
0 vote349 views1 answer
Initcap in mysql
SQL
-2 votes339 views2 answers
Sqlserver docker
SQL
14 votes360 views3 answers
Alter foreign key
SQL
0 vote404 views1 answer
Sql statement show all emails with dome
SQL
0 vote360 views1 answer
How to get specific salary in sql
SQL
0 vote360 views1 answer
Select insert new table sql server
SQL
4 votes339 views1 answer
Oracle error compilation line
SQL
0 vote334 views1 answer
Count the table indatabase
SQL
0 vote344 views1 answer
How to check even or odd in sql
SQL