Valor Minimo y Valor Maximo

[Libras]

teniendo en cuenta tu resultado podrias hacer esto:

Código SQL:

CREATE TABLE #temp
(
imdb INT,
nso VARCHAR(20),
producto VARCHAR(100),
VALUE DECIMAL(9,6),
valormax DECIMAL(9,6),
valormin DECIMAL(9,6)
)
 
 
INSERT INTO #temp VALUES (178399,'35350791','ACE-BLANCOS-DIAMANTE-2700GRS',53.8,53.8,53.8) 
INSERT INTO #temp VALUES (178399,'35350791','ACE-BLANCOS-DIAMANTE-2700GRS',56.6,56.6,56.6) 
INSERT INTO #temp VALUES (178399,'35350791','ACE-BLANCOS-DIAMANTE-2700GRS',56.64,56.64,56.64)
INSERT INTO #temp VALUES (178399,'35350791','ACE-BLANCOS-DIAMANTE-2700GRS',56.65,56.65,56.65) 
 
SELECT t1.imdb,nso,producto,VALUE,t2.minimo,t3.maximo FROM #temp AS t1
LEFT JOIN (SELECT MIN(VALUE) minimo,imdb FROM #temp GROUP BY imdb) AS t2 ON (t1.imdb=t2.imdb)
LEFT JOIN (SELECT MAX(VALUE) maximo,imdb FROM #temp GROUP BY imdb) AS t3 ON (t1.imdb=t3.imdb)
 

saludos!