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

1 vote217 views1 answer
Python escape mysql
SQL
0 vote255 views1 answer
Traccar mysql
SQL
0 vote218 views1 answer
Rename constraint postgresql
SQL
2 votes249 views1 answer
Get the mysql table columns data type mysql
SQL
1 vote169 views1 answer
Oracle character set
SQL
10 votes196 views2 answers
Mysql select timestamp group by day
SQL
1 vote231 views1 answer
Postgresql not in
SQL
0 vote213 views4 answers
Sql server date format yyyy-mm-dd
SQL
0 vote219 views1 answer
Mysql beautifier terminla
SQL
2 votes197 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL