Mysql count grouped rows

SELECT DISTINCT my_field, COUNT(*) FROM my_table GROUP BY my_field;

-- Count of grouped rows:
SELECT COUNT(*) FROM (
  SELECT DISTINCT my_field FROM my_table
);

Similar codes

0 vote321 views1 answer
How to check which table has data in mysql
SQL
0 vote295 views1 answer
Sql create table with references not primary key
SQL
11 votes307 views1 answer
Sql insert multiple rows from select
SQL
2 votes299 views2 answers
Useradd postgres
SQL
0 vote299 views1 answer
How to use query in nosql
SQL
0 vote329 views1 answer
Recently updated stored procedure in sql server
SQL
1 vote305 views1 answer
Postgres set column equal to another
SQL
5 votes324 views3 answers
Show indexes mysql
SQL
0 vote302 views1 answer
Sqlite higher or equal
SQL
0 vote327 views1 answer
Sql column contains special character
SQL