/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 vote284 views1 answer
Sql min
SQL
6 votes304 views2 answers
Join vs union
SQL
3 votes289 views1 answer
Sql multiple column index
SQL
2 votes301 views2 answers
Get all columns from table sql
SQL
1 vote291 views1 answer
Sql group by error
SQL
2 votes347 views2 answers
Create table mysql integer NOT null
SQL
6 votes295 views5 answers
Get current date sql
SQL
0 vote353 views1 answer
Dockerfile example for Django
SQL
0 vote295 views1 answer
Sql query for displaying age from oldest to youngest
SQL
7 votes300 views1 answer
Safe mode mysql
SQL