How to group by a single item without including it in the GROUP BY clause? : <p>My desire is to have a sales report grouped by product description that shows the quantity of each item  and the price. The problem I am running into is that I only want to group by the product description and not other fields that I have to include because there are aggregate functions in the SELECT clause. I have googled and searched everywhere and have not found a simple solution. </p>
