Thursday, April 4, 2019

Mysql new learning .. Use of keyword "having"

You can use Having with group by

SELECT COUNT( x ) AS cnt
GROUP BY o.x
HAVING cnt >1

No comments:

Post a Comment