SQL - SELECT CON GROUP BY

DECLARE @PRECIOS AS TABLE (Vigencia DATETIME, Articulo CHAR(1),  Precio MONEY)

INSERT INTO @PRECIOS VALUES

('2019-08-01','1', 100),

('2019-08-23','1',  110),

('2019-09-05','1',  115),

('2019-09-05','2',  50),

('2019-09-08','2',  52),

('2019-07-31','3',  200),

('2019-08-05','3',  210)

select MAX(Vigencia) AS Vigencia, Articulo, Max(Precio) as PrecioMaximo

from @PRECIOS

group by  Articulo

select MAX(Vigencia) AS Vigencia, Articulo, Max(Precio) as PrecioMaximo from @PRECIOS

group by  Articulo

Vigencia      Articulo        PrecioMaximo

2019-10-01       1                    115

WITH T AS

(

	SELECT Vigencia, Articulo, Precio,

		ROW_NUMBER() OVER(PARTITION BY Articulo ORDER BY Vigencia DESC) AS XX

	FROM @PRECIOS

)

SELECTVigencia, Articulo, Precio FROM T WHERE XX = 1;

GO