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 vote106 views1 answer
Stuff in sql server
SQL
1 vote112 views1 answer
Mysql history command
SQL
1 vote140 views1 answer
Oracle check table lock
SQL
8 votes187 views1 answer
Oracle search code in packages
SQL
2 votes112 views1 answer
Oracle sql drop column if exists
SQL
0 vote136 views1 answer
Mysql subtract month from timestamp
SQL
10 votes129 views2 answers
What is database
SQL
5 votes113 views1 answer
How to check nls format in oracle
SQL
2 votes121 views2 answers
Storing timezones in postgres
SQL
0 vote117 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL