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 vote378 views1 answer
Tsql update datetime
SQL
2 votes334 views1 answer
Get first 3 letters name in sql
SQL
2 votes345 views1 answer
Oracle convert run_duration to number
SQL
0 vote409 views1 answer
Mysql insert multiple rows based on select
SQL
8 votes361 views3 answers
Alter user root mysql
SQL
2 votes412 views1 answer
Capitalize 1st letter in sql server
SQL
6 votes352 views1 answer
Oracle desc table primary key
SQL
4 votes412 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
0 vote370 views2 answers
How to get the date from datetime in mysql
SQL
0 vote347 views1 answer
Sql count more than 1
SQL