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 402 views
2 answers 390 views
2 answers 375 views
4 answers 572 views
...