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 612 views
2 answers 559 views
2 answers 556 views
4 answers 805 views
...