sql sum group by – SQL SUM() function with group by

sql sum group by Using PostgreSQL GROUP BY without an aggregate function, PostgreSQL GROUP BY with SUM() function, PostgreSQL GROUP BY clause with the JOIN clause, PostgreSQL GROUP BY with COUNT() function, PostgreSQL GROUP BY with multiple columns and PostgreSQL GROUP BY clause with date column.

sql sum group by Tutorial

sql sum group by Tutorial: Count, Sum, Average, and Having Clauses or many more.

The syntax for the SUM function in SQL is:

SELECT SUM(aggregate_expression)
FROM tables
[WHERE conditions];

SQL SUM() function with group by

SELECT member_cd, 
SUM (advance_income) 
FROM orders 
GROUP BY member_cd;

Don’t miss : Sql Group By Multiple Columns

SQL SUM() using multiple columns with group by

SELECT subject, 
SUM (bonus_amt + final_amt) 
FROM member 
GROUP BY subject;

Group By single column

SELECT NAME, SUM(INCOME) FROM Member 
GROUP BY NAME;

Group By multiple columns

SELECT SUBJECT, YEAR, Count(*)
FROM Member
GROUP BY SUBJECT, YEAR;

HAVING Clause

SELECT NAME, SUM(INCOME) FROM Member 
GROUP BY NAME
HAVING SUM(INCOME)>3000; 

Using PostgreSQL GROUP BY clause with date column

SELECT 
	DATE(salary_date) mdate, 
	SUM(income) sum
FROM 
	salary
GROUP BY
	DATE(salary_date);

Using PostgreSQL GROUP BY with multiple columns

SELECT 
	member_id, 
	boss_id, 
	SUM(income) 
FROM 
	salary
GROUP BY 
	boss_id, 
	member_id
ORDER BY 
    member_id;

Don’t miss : Sql Query To Sum Two Columns Values Based On Its Record

Using PostgreSQL GROUP BY with COUNT()

SELECT
	boss_id,
	COUNT (salary_id)
FROM
	salary
GROUP BY
	boss_id;

I hope you get an idea about sql sum group by.
I would like to have feedback on my infinityknow.com.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.

Leave a Comment