SQL Query for SUM Function

Question

I have two tables Loan and Member. Now in Loan i have column totalamount and in Member i have column as membertype and in Loan i have various loan according to membertype. Now I want to use a SUM function to calculate totalamount according to the memtype.

I tried something as follows :

select sum(totalamount) from loan,member where member.mem_type='Regular'

Memberid of member table is a foreign key in Loan Table

Nimish Kulkarni
– Nimish Kulkarni

2012-04-07 11:34:12 +00:00
Commented Apr 7, 2012 at 11:34 — Nimish Kulkarni
– Nimish Kulkarni, Commented Apr 7, 2012 at 11:34
Please use ANSI 92 join style syntax.

Bogdan Sahlean
– Bogdan Sahlean

2012-04-07 11:45:47 +00:00
Commented Apr 7, 2012 at 11:45 — Bogdan Sahlean
– Bogdan Sahlean, Commented Apr 7, 2012 at 11:45

Arion · Accepted Answer · 2012-04-07 11:44:54Z

1

Do you mean like this:

select sum(totalamount) AS Total 
from loan
JOIN member ON Memberid=loan.Memberid   
where member.mem_type='Regular'

Or if you want to select mem_type as well then something like this:

select sum(totalamount) AS Total,member.mem_type 
from loan
JOIN member ON Memberid=loan.Memberid   
where member.mem_type='Regular'
GROUP BY member.mem_type

answered Apr 7, 2012 at 11:44

Arion

31.3k10 gold badges74 silver badges89 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Query for SUM Function

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related