/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 vote292 views1 answer
How to put value in parameters in mysqldataadapter
SQL
-1 vote313 views3 answers
My sql alter table
SQL
2 votes286 views1 answer
Postgresql transaction
SQL
9 votes295 views5 answers
Sql limit
SQL
4 votes295 views1 answer
Is there any command to change postgres password
SQL
0 vote343 views1 answer
Duplicate table: 7 ERROR: relation "migrations" already exists (SQL: create table "migrations" ("id" serial primary key not null, "migration" varchar(255) not null, "batch" integer not null))
SQL
0 vote306 views1 answer
Flexible search query delete table
SQL
0 vote270 views1 answer
Postgres add prefix to primary key
SQL
8 votes313 views1 answer
Ltrim sql
SQL
0 vote277 views1 answer
Sql query for getting data with join and count
SQL