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

posée 2 months ago63 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 2 months ago

Aucune réponse

Sign in and verify your email to post an answer.