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 vote250 views1 answer
Sql insert query list of dictionaries
SQL
0 vote245 views1 answer
Insert or update sql query
SQL
25 votes228 views4 answers
Metadata
SQL
0 vote196 views3 answers
Django.core.exceptions.improperlyconfigured: error loading mysqldb module. mac
SQL
0 vote239 views1 answer
Oracle show grants on table
SQL
1 vote258 views1 answer
Postgresql if 0 then 1
SQL
3 votes251 views2 answers
Postgres download
SQL
0 vote265 views1 answer
Sql column contains special character
SQL
0 vote261 views1 answer
Mysql remove bad character from all fields
SQL
0 vote232 views1 answer
Sql delete where x or y or z
SQL