/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 vote290 views1 answer
Get table column names sql ssms
SQL
6 votes281 views4 answers
How to remove unique key in mysql
SQL
8 votes300 views3 answers
Connect python to mysql
SQL
0 vote302 views1 answer
Postgres regex word boundary
SQL
0 vote269 views1 answer
Oracle query to see what scema i am working in
SQL
0 vote299 views1 answer
Show the colums of table sql
SQL
0 vote273 views1 answer
Google sheets filter rows above current cell
SQL
0 vote287 views1 answer
How to connect pgadmin with excel
SQL
0 vote333 views1 answer
Sql to excel pgadmin
SQL
0 vote335 views1 answer
Add two days to current date in sql when creating tables
SQL