/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

1 vote128 views1 answer
Sql Split string function
SQL
0 vote140 views1 answer
SQL authentication error
SQL
1 vote165 views1 answer
Sql server set variable if exists
SQL
1 vote139 views1 answer
Mysql count words
SQL
1 vote170 views1 answer
Drop colum oracle 18c
SQL
0 vote150 views1 answer
Select distinct after join
SQL
23 votes150 views1 answer
How remove column in mysql
SQL
11 votes214 views1 answer
Oracle insert from select
SQL
8 votes145 views1 answer
How to check mysql version in xampp
SQL
5 votes137 views5 answers
Find max number in sql
SQL