How to use SQL HAVING Clause in MySQL

1 Answer

0 votes
SELECT category, COUNT(category) AS category_count 
FROM s4i_all_info
GROUP BY category
HAVING COUNT(category) > 20

 



answered Oct 6, 2015 by avibootz

Related questions

3 answers 605 views
2 answers 553 views
2 answers 548 views
4 answers 800 views
...