/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

2 votes329 views1 answer
Db.relationship sqlalchemy flask
SQL
3 votes352 views1 answer
How to add unique constraint in mysql table
SQL
0 vote334 views1 answer
Oracle swap partition
SQL
3 votes280 views1 answer
If 0 return null else return query mysql
SQL
0 vote333 views2 answers
Add colum in sql
SQL
1 vote268 views1 answer
Restart identity postgresql
SQL
5 votes292 views1 answer
Sql first day of current year
SQL
0 vote320 views1 answer
VSCode SQL Server Connection error
SQL
5 votes346 views1 answer
Mysql add user with all privileges
SQL
11 votes335 views4 answers
MYSQL LOGIN
SQL