SELECT DISTINCT but get the sum of another column

[deansatch]

I have a table where there are multiple rows per order_number. Each row has a column for price and quantity.

 

I want to show a summary e.g.

order no: 123, qty: 55, total price: £2222

order no: 454, qty: 65, total price: £2652

etc....

 

If I use SELECT DISTINCT I can get the rows as one order number per row, but how can I add the price/quantities for each order instead of just getting the single values for these columns?

[deansatch]

Never mind...I used GROUP BY. Doh!