/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 vote354 views1 answer
Select users with same username
SQL
3 votes349 views2 answers
Mysql config user password
SQL
36 votes360 views6 answers
Delete from where sql
SQL
0 vote339 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
0 vote299 views1 answer
Big query add table rows to another table
SQL
0 vote354 views1 answer
Oracle session statistics
SQL
0 vote352 views1 answer
Print boolean in plsql
SQL
1 vote348 views1 answer
Oracle stop
SQL
0 vote377 views1 answer
Insert value in identity
SQL
0 vote332 views1 answer
Get only structure database mysql
SQL