Support Questions

Find answers, ask questions, and share your expertise

Who agreed with this solution

avatar
Contributor

Why?  Because COUNT(*) is an aggregate and to filter on a aggregate you would use a HAVING clause, or use an in-line view as you have done.

 

 

View solution in original post

Who agreed with this solution