Not contained in either an aggregate function or the GROUP BY

Hi;

i am trying sum all the price base on referenceNo, but i get the following error;

Column 'buyerName' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

my sql statment

select buyerName, id, category, productName, Sum(price) as "price", date, referenceNo from elena where referenceNo='d11';



Could anyone help ? Thanks

to understand this error message, follow along with this logic --

1. the SELECT clause contains an aggregate function, SUM(price)

2. the SELECT clause also contains several non-aggregate columns (six of them)

3. these other six columns must therefore also be in the GROUP BY clause but this is actually missing

does the error message make sense now?

put all six of the non-aggregate columns into the GROUP BY clause

Thanks a lot, i fix the problem already