SQL: What is the difference between GROUP BY and HAVING clauses?
asked 2 months ago64 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.
No Answers
Sign in and verify your email to post an answer.