1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
| With Req (pa_article, pa_date, PA_PrixBrut, rn) as
(
SELECT PA.pa_article, PA.pa_date, PA.PA_PrixBrut
, row_number() over(partition by PA.pa_article order by PA.pa_date desc)
FROM dbo.PrixArt AS PA
INNER JOIN dbo.Articles AS AR
ON AR.AR_Code = PA.PA_Article
WHERE AR.AR_Actif = 1
AND LEFT(AR.ar_code, 4) IN ('3000', '3010', '3020', '3300', '3310', '3320', '3330', '3400', '3410', '3420')
AND AR.AR_Code LIKE '%D%'
AND PA.PA_Monnaie = 'CHF'
)
SELECT pa_article, pa_date, PA_PrixBrut
FROM Req
WHERE rn = 1; |
Partager