Return Last Record in Database

[Pfaff]

Greetings,

I have a database which stores forecast data for the last 18 months. Each forecast created shows data for each item over the next 18 months. Any given month may show up to 18 different data points from the 18 different forecasts. For example:

ItemID	Forecast_On	ForecastQty	Month
Item1	7/1/2014	9500	10/1/2014
Item1	8/1/2014	10000	10/1/2014
Item1	9/1/2014	9700	10/1/2014
Item2	7/1/2014	2450	10/1/2014
Item2	8/1/2014	2600	10/1/2014
Item2	9/1/2014	2900	10/1/2014

The query I run will show every record, which is fine for a waterfall forecast, where I can see how much the forecast has changed over time, but I want to create a query where it returns only the forecast from the most recent "Forecast_On" date, otherwise known as the "Final Forecast".

I hope my question is clear enough. I would love some feedback on this.

Thanks.

[June7]

Try:

SELECT TOP 1 * FROM tablename ORDER BY Forecast_On DESC;

That should return the two 9/1/2014 records.

[Pfaff]

Thank you June7. That worked perfectly.