Showing posts with label Aggregate functions example in sql. Show all posts
Showing posts with label Aggregate functions example in sql. Show all posts

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