/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 votes173 views1 answer
Laravel sql String
SQL
0 vote175 views1 answer
Sqlite get date only
SQL
8 votes183 views4 answers
How to calculate the age from date of birth in python
SQL
0 vote177 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
1 vote179 views1 answer
Sqlite update from another table
SQL
0 vote197 views1 answer
Laravel SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema = testDB and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote174 views1 answer
Sql search all columns of database oracle sql
SQL
1 vote164 views1 answer
Neo4j display all nodes and relationships
SQL
0 vote193 views1 answer
Mysql streaming example
SQL
0 vote175 views1 answer
Oracle current timestamp
SQL