select * and SUM?

[mfacer]

hey... I'm trying to get all the records from the table using...

SELECT * FROM expenses WHERE employeeID = xxxx

that's ok, but I also want to total the expenses.... I tried

SELECT * SUM(claim_amount) AS "claim_amount" FROM expenses WHERE employeeID = xxx

but that doesnt seem to work.... any ideas where I'm going wrong?

thanks...

[devinemke]

SELECT SUM(claim_amount) AS claim_amount FROM expenses WHERE employeeID = 'xxx'

[Dr_John]

Or, if you NEED the other attributes,

SELECT a, b, c, etc, SUM(claim_amount) AS claim_amount
FROM expenses
WHERE employeeID = 'xxx';

i.e. name the other attributes you want instead of using *, and of course miss out the orginal claim_amount from teh list

[mfacer]

thanks guys.. I'll give it a go - I need the other columns too... so will have to use the second option 🙂

[Drakla]

You're missing a group by clause on that last one Doc, easily done.

SELECT a, b, c, etc, SUM(claim_amount) AS claim_amount
FROM expenses
WHERE employeeID = 'xxx'
GROUP BY employeeID
;