Tuesday, February 20, 2024

Aggregate functions example in sql

SELECT
sum(Total) as [Total Sales],
round(Avg(Total),2) as [Average Sales],
Max(Total) as [Max Sale],
Min(Total) as [Min Sale],
Count(*) as [Sales Count]
from Invoice

No comments:

Post a Comment