Answers for "get count in select query and then use it in group by that count in mysql"

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
);

Posted by: Guest on April-23-2021

Code answers related to "get count in select query and then use it in group by that count in mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "get count in select query and then use it in group by that count in mysql"

Code answers related to "get count in select query and then use it in group by that count in mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "get count in select query and then use it in group by that count in mysql"

Code answers related to "get count in select query and then use it in group by that count in mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us