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

8 votes281 views3 answers
Postgres database sizes
SQL
0 vote266 views1 answer
Logtash mysql cofiguration file
SQL
0 vote259 views2 answers
Sqlalchemy core in clause
SQL
0 vote258 views1 answer
What alter does in db
SQL
3 votes245 views1 answer
Delete all content in table mysql
SQL
0 vote275 views1 answer
Postgresql list extensions
SQL
0 vote269 views1 answer
Insert or update sql query
SQL
3 votes242 views2 answers
Mysql add 2 hours
SQL
0 vote286 views1 answer
SQLServerException.makeFromDatabaseError
SQL
9 votes272 views4 answers
Postgresql export database
SQL