Hi

I need to write a query with pulls count for a column based on some condition and i need to figure out if the count is less than given constant value.


example of the query trying with:

select count(R_id) , G_id from Temp_map
where x_id is null or x_id = 2
and count(R_id) < 2
group by G_id


thanks for help.

select count(*) , G_id from Temp_map
where x_id is null or x_id = 2
group by G_id
having count(*) < 2

WHERE filters the rows
HAVING filters the Group By