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

posée 4 days ago9 vuesen

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

Environnement :SQL Server 2016Windows

🤖 Diagnostic IA

Généré par IA. Ce n'est pas une réponse — la communauté ci-dessous le confirme ou le corrige. Vérifiez toujours avant de vous y fier.

posée 4 days ago

Aucune réponse

Sign in and verify your email to post an answer.