sum() and a field request in a smae quesry

[pelegk2]

is it possible in the same select to ask for a certain field and in the same time to do a sum() on a certain col?
if not then why?
thnaks in advance
peleg

[barand]

You can

SELECT a, SUM(b) FROM atablename GROUP BY a

which will give the totals of b for each value of a

Is that what you mean?

[pelegk2]

i will check and tell u🙂