Hi all:

Consider the following data:

Sale Date   P         Q
1/4/06      9         3
2/4/06      2         7
2/4/06      3         8
2/4/06      6         6
3/4/06      1         5
5/4/06      4         2
5/4/06      5         9

I want to construct a select statement that will return the following:

latest_date  P_lt  q_lt  date-1  p-1  q-1  date-rest  p-rest  q-rest
5/4/06       9     11    3/4/06  1    5    {}         20      24

In other words, I want to get a total of products sold on the latest date, whatever that is; products sold on the date before the latest date, whatever that is; and products sold on all the other prior dates.

Can this be done?

Thanks,

Yossi