HAVING vs. WHERE use case

101 views Asked by At

I have a column that its value is set from enum.

I would like to check if there are lines that mistakely were set to a value nor from the enum, grouped by their value.

The following queries retrive the same results:

Using HAVING

select COLUMN1, COUNT(*) as cntr  
from TABLE1
group by COLUMN1
having COLUMN1 not in ('enum_value_1', 'enum_value_2')  

Using WHERE

select COLUMN1, COUNT(*) as cntr  
from TABLE1  
where COLUMN1 not in ('enum_value_1', 'enum_value_2')
group by COLUMN1  

What should I use?

0

There are 0 answers