What is the rule to use group by having and where clause

Question

Hey,

I want to use where, group by and having in a same query but I am getting syntax error. So what is the sequence to use these at a time?

Answer 1

Hi samar,

this is a very common mistake .\

So if you want to use there three at a time in one query then the sequence will be - where-group by -having

example:

Select * from employee where age>=32 group by(department_id) having count(transaction_id) >1

Thank you,

I hope it will help you