--top 5 jobs per stock code
SELECT
ROW_NUMBER() OVER(PARTITION BY m.StockCode ORDER BY w.JobStartDate DESC)
, m.StockCode, m.Description, m.Ebq , w.JobStartDate , w.QtyToMake
FROM InvMaster m JOIN WipMaster w
ON w.StockCode=m.StockCode
WHERE w.JobStartDate > GETDATE()-90
ORDER BY w.JobStartDate DESC