SELECT TOP 3 * FROM [HistoricalSummary] WHERE business=@business ORDER BY [year] descBut now here's the problem. I want the order of these records to be sorted by year lowest to highest. So this is the opposite of what is needed to get the 3 latest records. Has anyone dealt with anything like this before?
>SELECT * >FROM (SELECT TOP 3 * FROM [HistoricalSummary] WHERE business=@business ORDER BY [year] desc) Tbl1 >ORDER BY Year >Thank you Borislav. So simple yet so elusive.