are you looking at top 5 values for each year?
then use
SELECT *
FROM
(
SELECT ROW_NUMBER() OVER (PARTITION BY YEAR(Table_PurchaseOrder_Information.CreatedDate) ORDER BY Table_PurchaseOrder_Information.CreatedDate DESC) AS Seq,
Table_PurchaseOrder_Information.PO_Number, Table_PurchaseOrder_Information.Supplier, Table_PurchaseOrder_List.Unit_Price,
Table_PurchaseOrder_Information.CreatedDate
FROM Table_PurchaseOrder_Information INNER JOIN
Table_PurchaseOrder_List ON Table_PurchaseOrder_Information.ReferenceNumber = Table_PurchaseOrder_List.ReferenceNumber
)t
WHERE Seq<=5
ORDER BY CreatedDate DESC
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Year Problem Query
Posted - 01/05/2013 : 07:40:44
