/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 vote202 views2 answers
Create new table plsql
SQL
10 votes214 views1 answer
Oracle view dependencies
SQL
0 vote202 views1 answer
Recover deleted data from mysql database
SQL
1 vote198 views1 answer
Mysql monthname
SQL
19 votes208 views5 answers
Mysql between date range
SQL
0 vote191 views1 answer
Get all employees if name ends with in sql
SQL
1 vote214 views2 answers
Mysql between
SQL
1 vote154 views1 answer
Convert money to varchar sql server
SQL
11 votes193 views2 answers
Having keyword sql
SQL
1 vote222 views2 answers
Oracle leftmost characters
SQL