Scribd
Upload
26 views2 pages

SQL Aggregate Functions Explained

The document describes SQL aggregate functions like SUM, COUNT, AVG, MIN, MAX and how to use them with GROUP BY and HAVING clauses. It shows the syntax for using these functions to aggregate data and filter groups.

Uploaded by

seraphine2031038
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
26 views2 pages

SQL Aggregate Functions Explained

The document describes SQL aggregate functions like SUM, COUNT, AVG, MIN, MAX and how to use them with GROUP BY and HAVING clauses. It shows the syntax for using these functions to aggregate data and filter groups.

Uploaded by

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

SUM:

SELECT SUM(COLUMN_NAME)
FROM TABLE_NAME ;

SELECT SUM(COLUMN_NAME)
FROM TABLE_NAME
WHERE CONDITION;

TOTAL SUM/ GROUP BY:


SELECT COLUMN NAME, SUM(TOTAL AMOUNT)
FROM TABLE NAME
GROUP BY COLUMN NAME;

SELECT COUNT (CUSTOMERID), COUTNRY


FROM CUSTOMERS
GROUP BY COUNTRY;

COUNT/ GROUP BY:


SELECT COUNT(COLUMN_NAME)
FROM TABLE NAME
WHERE CONDITION (EX: sales region=’north’ and total amount <’5000’ ;
DON’T WHERE USE HAVING CONDITION

AVERAGE:
SELECT AVG (COLUMN_NAME)
FROM TABLE_NAME
WHERE CONDITION ;
MIN AND MAX:
SELECT MAX (COLUMN_NAME)
FROM TABLE_NAME
WHERE CONDITION ;

SELECT MIN (COLUMN_NAME)


FROM TABLE_NAME
WHERE CONDITION ;

GROUP BY HAVING:
SELECT COLUMN_NAME
FROM TABLE_NAME
WHERE CONDITION
GROUP BY COLUMN NAME
HAVING CONDTION ;

GROUP BY/HAVING:
SELECT COLUMN_NAME, SUM(TOTAL AMOUNT)
FROM TABLE_NAME
GROUP BY COLUMN NAME
HAVING SUM(TOTAL AMOUNT)>250000;

HAVING COUNT

You might also like