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

5 votes223 views1 answer
Oracle list functions
SQL
1 vote218 views1 answer
Sql convert month name to number
SQL
0 vote200 views1 answer
Sql trying to delete database in use
SQL
6 votes236 views2 answers
Mysqldump password in file
SQL
0 vote213 views1 answer
Wordpress delete post revisions older than date "sql"
SQL
1 vote208 views1 answer
Input in mysql
SQL
0 vote195 views1 answer
Sql convert datetime to year
SQL
5 votes202 views2 answers
Update all rows mysql
SQL
-1 vote148 views2 answers
Datetime sql server week
SQL
1 vote209 views1 answer
Failed to stop mysqld.service: Unit mysqld.service not loaded.
SQL