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

7 votes189 views1 answer
Sql management studio display line numbers
SQL
1 vote209 views1 answer
How to transfer pandas datafra,e to sqlite
SQL
0 vote190 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL
23 votes206 views1 answer
How remove column in mysql
SQL
0 vote300 views1 answer
Mysql grant access to one database
SQL
0 vote180 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
16 votes248 views3 answers
Order by sql query
SQL
0 vote210 views1 answer
Snowflake drop column
SQL
1 vote202 views1 answer
Clear screen command in psql
SQL
14 votes202 views2 answers
Oracle export trigger ddl
SQL