help with a query

Hi,

Hope someone can help me with a query:

I have the following table: table1, with 2 columns: sales, date

what I want to do is:

select and add the value of sales based on date:

i.e.
result will be:

(sales in year 1998), (sales in 1999), (sales in 2000), (total sale)

Can I do it in ONE query?

Thanks a lot!

Sent via Deja.com
http://www.deja.com/ Received on Wed Jan 10 2001 - 15:35:45 CST