What is the difference between where and having clause

Question

Anonymous · Accepted Answer

Where clause
It's a row operation method,
It cannot hold agg functions,
Group by comes after where clause
Having clause
It is a column operator,
It holds agg functions,
It's is placed after group by clause

PwC

PwC interview question

Interview Answer

Want the inside scoop on your own company?

Bowls

Followed companies

Job searches