Get latest date, and previous
Posted on 2013-06-05
I would like to ask for help with a sql query that I need to use later in a report.
My table contains only 4 columns: Item, Item Description, Date, Price
The table gets updated weekly on Fridays. I need to retrieve the last two most recent Prices.
For example, if today I run the query, I would get all rows for 5/31/2013 and 5/24/2013
Hopefully to get some help with how to calculate this dates, or some direction where I can find some examples or information that can help me figure this out.
Thank you very much.