Scribd
Upload
7 views

5.aggregate Functions in SQL

Uploaded by

Rakshak Ponnarasan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
7 views

5.aggregate Functions in SQL

Uploaded by

Rakshak Ponnarasan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
You are on page 1/ 19

Aggregate functions

in SQL
Aggregate functions
Aggregate function is a function where the values of multiple rows are
grouped together as input.
Various Aggregate Functions
• Count()
• Sum()
• Avg()
• Min()
• Max()
SELECT COUNT(*) FROM PRODUCT_MAST;
• SELECT COUNT(*) FROM PRODUCT_MAST WHERE RATE>=20;
• SELECT COUNT(DISTINCT COMPANY) FROM PRODUCT_MAST;
• SELECT COMPANY, COUNT(*) FROM PRODUCT_MAST
GROUP BY COMPANY;
• SELECT COMPANY, COUNT(*) FROM PRODUCT_MAST
• GROUP BY COMPANY
• HAVING COUNT(*)>2;
• SELECT SUM(COST) FROM PRODUCT_MAST;
• SELECT SUM(COST) FROM PRODUCT_MAST WHERE QTY>3;
SELECT SUM(COST) FROM PRODUCT_MAST
WHERE QTY>3 GROUP BY COMPANY;
SELECT COMPANY, SUM(COST) FROM PRODUCT_MAST
GROUP BY COMPANY HAVING SUM(COST)>=170;
Max()
• SELECT MAX(RATE) FROM PRODUCT_MAST;
• SELECT COUNT(*) FROM PRODUCT_MAST;

You might also like