SQL: What is the difference between GROUP BY and HAVING clauses?

asked 4 days ago9 viewsen

0

I would like to know the difference between group by and having select company,sum(netamount) as amt group by company having amt>1000000

Environment:SQL Server 2016Windows

🤖 AI diagnosis

AI-generated. Not an answer — the community below confirms or corrects it. Always verify before relying on it.

asked 4 days ago

No Answers

Sign in and verify your email to post an answer.