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 vote288 views1 answer
How to search query in python3 sqlite3
SQL
5 votes266 views3 answers
Mysql check if null or empty string
SQL
1 vote270 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
4 votes332 views1 answer
Fatal error: libpq-fe.h: No such file or directory
SQL
4 votes287 views1 answer
Conda install sqlalchemy
SQL
0 vote276 views1 answer
Mysql preg replace
SQL
0 vote283 views1 answer
Oracle query archivemode
SQL
0 vote290 views1 answer
Postrgres trunc
SQL
8 votes331 views2 answers
Default sql server port
SQL
1 vote275 views1 answer
Oracle activate job
SQL