Condition checking while using sum() in mysql

Question

AM NEW TO MYSQL... HELP ME TO SORT OUT THIS...

I have a result like

 NO,     TYPE,  FEE_AMT
'2156', 'FTP2', 100.00
'2156', 'FTP4', 200.00
'2156', 'FTP5', 100.00
'2156', 'FTP6', 100.00
'2156', 'FTP3', 100.00

I want to sum all FEE_AMT, in which if the type='FTP5' I want to square the respective FEE_AMT and then add... I have tried sum(fee_amt) only...

EXPECTED OUTPUT IS: 10,500...

edit

100+200+(100*100)+100+100

I WANT TO SQUARE THE FEE AMOUNT IF FEE TYPE='FTP5'

THANKS IN ADVANCE... :)

Can you show us a reproducible sample and output? I don't see how you're getting 10,500 from your question. Do you want the sum of the squares, or the square of the sum? — Tim Biegeleisen
– Tim Biegeleisen, Commented Dec 18, 2015 at 6:08
Mr Tim... Please see my edited question... Thanks for your response first of all... — Monicka Akilan
– Monicka Akilan, Commented Dec 18, 2015 at 6:13

Tim Biegeleisen · Accepted Answer · 2015-12-18 06:14:48Z

2

SELECT SUM(
    CASE WHEN TYPE='FTP5' THEN FEE_AMT*FEE_AMT ELSE FEE_AMT END) AS FeeSum
FROM yourTable

answered Dec 18, 2015 at 6:14

Tim Biegeleisen

526k32 gold badges324 silver badges399 bronze badges

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

1 Comment

Glad to help. Have a look here if you want to see a really ugly query.

Vipin Jain · Accepted Answer · 2015-12-18 06:33:23Z

0

SELECT SUM( if(TYPE='FTP5',FEE_AMT*FEE_AMT,FEE_AMT)) AS FeeSum FROM yourTable

answered Dec 18, 2015 at 6:33

Vipin Jain

3,77618 silver badges36 bronze badges