analytic function

Hi,

using a select like:

select max(date) over (partition by...)

how can I retrieve a value from the same row than the max(date) ? For example, how can I find the price value for the max(date) over that partition ?

thank you Received on Fri Jun 23 2006 - 01:08:43 CDT