DarthEvader
Technical User
I have a table where each row contains a single day's pricing information. The table has one row per "price date", going back to May of 2002.
I am trying to figure a way to select the row of the final "price date" of every month. The problem is that the final price is not always on the last day of the month. So for example, for June 2007 I would want the price from Friday June 29.
So I need something that will act like a max(price_date) function, except return the maximum date per month. Can anyone think of a good way to do this?
I am trying to figure a way to select the row of the final "price date" of every month. The problem is that the final price is not always on the last day of the month. So for example, for June 2007 I would want the price from Friday June 29.
So I need something that will act like a max(price_date) function, except return the maximum date per month. Can anyone think of a good way to do this?